I have a workbook with 2 worksheets in it.
"MC Tracker Data" & "Tracking"
The control worksheet is "MC Tracker Data"
The "Tracking" worksheet gets deleted and replaced daily.
The key field for Sync is Column C in both worksheets. The columns stay static, but rows may be deleted or added.
"MC Tracker Data" row 3 has the corresponding column numbers from "Tracking" where the data is to be updated from.
"Tracking" columns "Y" to "AG" is the tough one. The #/# must be split to the corresponding columns in "MC Tracker Data" The snippets of code to break them is in Module 1.
I need to look up the key field in "MC Tracker Data"
Find the corresponding key field (Row) in "Tracking"
Update all columns associated by the mapping
Split the text in cells "Y to AG" and populate the columns in "MC Tracker Data"
I am terrible with loops, so help would be appreciated.....