Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatically compare and ecit two workbooks
I have a report that is pulled via Crystal Reports and imported into Excel
2000. I pull this every day. I need a way to compare and update the data from one day to the previous day. For example, I need to compare the item numbers listed in Workbook 1(previous report) - column B to the item numbers in Workbook 2(current report) - column A. If there is an item number not found in the previous workbook, then I need the entire row to be added. If it is found, I need it to be ignored. Is this enough information? I appreciate anyone's help. -Wayne |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|