Hi,
I have a workbook with a sheet called query, and another sheet of exiting orders, I am trying to create a macro that will look at Columns A and B to create a unique ID and see if that same combination exists on my existing order sheet. If the line items from the Query do not exist, then add them to the Existing Orders sheet. Any help would be greatly appreciated.
Here's one option...
Please Login or Register to view this content.
Last edited by sintek; 05-13-2019 at 03:45 PM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Wow, this is amazing, can I ask if it would be possible for you to put comments in on the step through - I would like to know how this functions. Thank you again!
See amended post above...Thanks for rep +
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks