Compare two spreadsheets to find differences.

[Guest]

Problem: I work with two spreadsheets daily in which I need to compare two
columns and extract, note or highlight differences. First worksheet has that
days sales order numbers, which is then sent to our warehouse for shipping.
Second spreadsheet is sent back from warehouse with sales order numbers and
their respective tracking numbers.

Issue: Occassionaly sales orders slip through and don't get shipped. I need
to compare both spreadsheets and find the sales order numbers on the 1st
sheet that don't appear on the 2nd sheet and therefore, didn't ship.

Can anyone spell UNHAPPY CUSTOMER?

Solution: Would like a command or formula that will compare sales order
colums in both spreadsheets and extract those numbers that didn't ship to a
3rd spreadsheet.

Thanks,

Toby

 

[Dave Peterson]

See one reply at your first post.

Problem: I work with two spreadsheets daily in which I need to compare two
columns and extract, note or highlight differences. First worksheet has that
days sales order numbers, which is then sent to our warehouse for shipping.
Second spreadsheet is sent back from warehouse with sales order numbers and
their respective tracking numbers.

Issue: Occassionaly sales orders slip through and don't get shipped. I need
to compare both spreadsheets and find the sales order numbers on the 1st
sheet that don't appear on the 2nd sheet and therefore, didn't ship.

Can anyone spell UNHAPPY CUSTOMER?

Solution: Would like a command or formula that will compare sales order
colums in both spreadsheets and extract those numbers that didn't ship to a
3rd spreadsheet.

Thanks,

Toby