Good Afternoon,

I have 2 spreadsheets in 2 separate workbooks. The both contain lists of
orders. The first is a list of recent orders, while the second is a list of
older orders. All records are identified in column A by a PO#. I need to
compare the older orders and newer orders to find records in the new order
list not already found in older order list. Once I find the newer orders
that are not in the other list, I need to copy them ( the entire data set )
and append them to the older orders list. I know it sounds like a hassle and
it has been for me as I do it all manually now. I'm hoping that there is a
faster way to make this happen. Any advice would be appreciated.

Thanks in advance and I look forward to your response.

take a look here for possible solutions:

http://www.cpearson.com/excel/duplic...tractingUnique

"john mcmichael" wrote:

Good Afternoon,

I have 2 spreadsheets in 2 separate workbooks. The both contain lists of
orders. The first is a list of recent orders, while the second is a list of
older orders. All records are identified in column A by a PO#. I need to
compare the older orders and newer orders to find records in the new order
list not already found in older order list. Once I find the newer orders
that are not in the other list, I need to copy them ( the entire data set )
and append them to the older orders list. I know it sounds like a hassle and
it has been for me as I do it all manually now. I'm hoping that there is a
faster way to make this happen. Any advice would be appreciated.

Thanks in advance and I look forward to your response.