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 |
All times are GMT +1. The time now is 10:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com