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!
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!