1 Attachment(s)
Update data from mapping table to another worksheet
Hi,,
I need help urgently on a macro to fill a spreadsheet based on a mapping table.
Mapping sheet givves us the mapping table. Column header marked in yellow is the primary key.
Destination will have this header in any column of the worksheet. VBA should identify the
the column and then values under those and systematicallyy fill the rest of the columns
again spread anywere in the destination sheet.
For eg. Outright should have NDF, FX & Cash on the same row under respective headers.
Attaching file for better understanding.
Thanks
Attachment 16025