Excel Makro / VBA Code needed

Hi

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.

I hope this makes sense