I hope this is a simple plea for help.
Here is my situation:
A folder filled with XML exported files and the number and name can vary - Done
XML mapping for excel to import into premapped XML Schema - Done
All xml files imported in one by one in a loop based - done
So the worksheets that i imported the XML flies are name as of the "B1" value the file is called "FinalAOMTfr.xls"
Now i have another file called worklog.xls, this file contains named individuals (listed under workbook FinaAOMTFR) starting from E1 F1 G1 .... and so on so forth .. underneath each heading has a list of tasks that are located in FinalAOMTfr.
What i want to do is that run a macro that would compare the name in the worklog.xls with the B1 value in the FinaAOMTfr and then copy H3:H48 in FinaAOMTfr to the respective individuals name under the worklog E1 F1 G1... depending on the name.
Im absolutely stuck and dont know how to loop and compare and copy.
Anyhelp would be appreciated.
Thank you
Bookmarks