PDA

View Full Version : Compare Rows from 2 diff WSs and combine on 3rd sheet



wolf.stalker
09-22-2010, 10:00 AM
The title is rather crappy and doesn’t exactly express what i am looking to do here.

i have a workbook with 3 sheets. sheet one contains orders and has 4 fields (D being the key). sheet two contains billing (for orders) and should match up with sheet one (also using D as key).

on sheet 3, i am going to have ordered on one side separated by a column then the actual billed order.

in the event that something was ordered but has not yet been billed (no match), then i will put the ordered side down and then for the billed side have something like "Not in yet" or something.

i am guessing but should have between 55,000-65,000 orders max.

What is the most efficient way i can process ordered against billed and have them matched up on sheet 3 (archive) ?

thanks you for any help you may be able to provide!

wolf.stalker
09-22-2010, 10:05 AM
Thought i attached my "sample" file but i guess it didn't go...so here it is.

wolf.stalker
09-24-2010, 12:13 PM
any thoguhts at all on this?