Can anyone provide a solution to this scenario???

I have two worksheets with shipping information. First has sales order
numbers for our warehouse to ship and second sheet comes back to us with
sales order numbers and their respective tracking number from the warehouse.

Problem: Sometimes sales orders don't ship and I need to quickly compare the
two spreadsheets to see which sales order numbers from the first sheet don't
appear in the second sheet and therefore didn't ship.

I've scoured the Internet and can't find anything that quite works. A
formula that would seach both columns of info and record all sales order
numbers onto a 3rd spreadsheet would work best.

Thanks,

Toby

"Igor Green" wrote:

You may check our CompareIt tool (http://www.grigsoft.com/) - it can
compare excel files.

Igor Green
http://www.grigsoft.com
Compare It! + Synchronize It! : Files and folders comparison never was
easier!