Compare two spreadsheets to find differences.
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 |
See one reply at your first post.
Toby wrote: 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 |
All times are GMT +1. The time now is 08:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com