I need to move table data from one excel list to another, based on a set of
field name mappings from one list to the other maintained on a third sheet.
I understand that the LOOKUP function will return the corresponding field name for the other sheet, but how do I move the data automatically?
I'd appreciate any pointers / sample code.
Sheet 1 contains columns titled 'YTD' and 'Mech'
Sheet 2 contains columns titled 'Budget' and 'Spent'
Sheet 3 contains two columns holding the mapping list:
YTD -> Spent
Mech -> Budget
I want to automatically move data in the 'YTD' column on sheet 1 to the corresponding column in sheet 2 (the column 'Spent' in this case) based on the field name mappings maintained in sheet 3.
I hope the purpose is clear. Of course, my sheets have many more columns.