Hi All

I need to analyse out a transaction listing based on the account codes.
I have set up VLookup tables but I would like to have a macro that would
insert the columns with the formulas. The range will be dynamic.

E.g.

Account Number Insert 1 Insert 2 Insert 3 Amount

111 Vlookup(1) Vlookup(2) Vlookup(3)
222

Thanks in advance