I have attached both test sheets... What I am working with is Test1 is an order system sheet we will say... and Test2 is the sheet I get sent daily in an email...
I need to be able to run a macro on Test2 that will find each order number from it and find the order number in Test1 and place the corresponding Billing Doc # & Price for that Order # in the Test1 sheet... This should be an easy task but I cannot seem to figure out a way to get it working... Thanks for all the input ahead of time!!! Remember the data in TEST2 sheet is always changing and the TEST1 sheet will be a huge list of numbers these are only test sheets...
Test2.xlsx
TEST1.xlsx
Bookmarks