I have a workbook with 4 worksheets in it: "Checksheets-ALL", "Orbit Dump", "MC Tracker Data", "Tracking"
I have had an expert help with the development of the "Daily Update" so far. It is based on a "Unique Identifier" Column A in "Checksheets-ALL" & a "Unique Identifier" in Column A of "Orbit Dump" This allows for the code to run and validate matching cells in the two sheets.
The update I require is with additional fields. The mapping is Attached. (Mapping.xlsx)
Additional to the Daily update, "Checksheets-ALL" requires updates from the two other sheets that are imported daily as per the mapping.
I think this is probably a looping exercise, but with 17,000+ rows of data, it would be a long process. Is there an easier and faster way to perform this?