Hello,
I am regrettably in over my head with a project at work.
I am hoping someone can offer some vba assistance.
I have an excel workbook with four sheets.
Sheet one simply has just three columns of data (though many thousands of lines long)
Column A values represent the inventory (part number)-- column B represents
the qty ordered--and column C data represents the ship date.
Sheet Two is the same column and data set up but represents the inventory-qty-and ship date 24 hours later.
What I need to happen is to have Excel compare the sheet two data to the previous days data located on sheet one and populate sheet three with only the brand new customer orders. Can anyone help?
Bookmarks