Dear all,
The task is to come up with a macro that gets data from a CSV file on my desktop and then fills the data into an XLSM Sheet.
I have attached both files to this thread.
After data is loaded, the macro should map the data in the following scheme and fill the sheet accordingly:
Column A in AG
C in D
E in AH
F in A
G in F
I in I
J in G
K in E
L in J
M in M
O in P
Please note
- that the CSV file has leading Zeros in Column "I" and in "L"
- the header row in the XLSM file must not be changed
Once that is completed, the macro should save the sheet as a new csv file to my desktop.
Thanks in advance!
Bookmarks