Hi, hnpsingh,
I actually do have a small problem with your last request for placing orders into Follow up for Orders from Orders if the ID or Name are not in Company. I could best work around that if we plcaed a makr in Sheets Orders for all those orders which have been placed into Consolidated. The other way would be to check each order number with Consolidated via WorksheetFunction.CounIf to decide whether to put this into Follow Up. This section is missing (waiting on your response for that).
Code goes into a normal module and needs to be started from there (either place the cursor into the procedure and press F5 for complete, F8 for Step through) or start from Excel by ALT+F8, choose macro and run:
Ciao,
Holger
Bookmarks