We need an excel macro or VBA code which automatically puts bank statement page columns into columns automatically based on what is in the detail column. For example if the client is VAT Registered the vat amount is automatically calculated and the net figure goes into the appropriate column.
For example
Date / Detail / Amount VAT Registered - Yes / No If VAT Registered net figure it put into a VAT column (20%) If not VAT Registered Gross figure is put into the appropriate column - ie Telephone column is BT / EE / Vodafone / Three etc
We will need a way to have a library page or another way to do it, that we can enter typical names of companies that will go into each column.
Beginner SolidWorks Modeling Tutor Category: 3D CAD, 3D Design, 3D Drafting, 3D Modelling, 3D Rendering, Finite Element Analysis, Mechanical Engineering, Solidworks Budget: $250 - $750 USD
Create 50 Personal Gmail Accounts Category: Account Management, Customer Support, Data Entry, Data Processing, Email Handling, Internet Research, Project Management, Security, Technical Support, Time Management Budget: ₹100 - ₹400 INR
11-May-2026 15:57 GMT
Make My Fusion360 AutoCAD Design 3D-Print Ready Category: 3D CAD, 3D Design, 3D Modelling, 3D Printing, 3D Rendering, AutoCAD, CAD / CAM, Fusion 360, Mechanical Design, Mechanical Engineering Budget: ₹600 - ₹1000 INR
11-May-2026 15:57 GMT
Custom React Application Development Category: AngularJS, API, Frontend Development, Git, JavaScript, Node.js, NoSQL Couch & Mongo, Web Development Budget: ₹12500 - ₹37500 INR