Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro - Insert column with VLookups
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Column with macro | Excel Discussion (Misc queries) | |||
Macro- Column Insert | Excel Discussion (Misc queries) | |||
Macro- Column Insert | Excel Discussion (Misc queries) | |||
Macro- Column Insert | Excel Discussion (Misc queries) | |||
Dynamic column insert (macro) | Excel Discussion (Misc queries) |