Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing 2 worksheets
Here is what I am trying to do. I have a spreadsheet sent to me every
month that lists all of the sales for every location and every part number. The list is well over 10,000 lines. This spreadsheet is updated every month, new information is added to the old report. I need to be able to see what is being added every month. So... I would like to find and/or remove the information that was in last months file from this months so that only the new stuff is shown Thanks, Smoky --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing 2 worksheets
See Chip Pearson's page on working with Duplicates and Uniques.
http://www.cpearson.com/excel/duplicat.htm -- Regards, Tom Ogilvy "Smoky2010 " wrote in message ... Here is what I am trying to do. I have a spreadsheet sent to me every month that lists all of the sales for every location and every part number. The list is well over 10,000 lines. This spreadsheet is updated every month, new information is added to the old report. I need to be able to see what is being added every month. So... I would like to find and/or remove the information that was in last months file from this months so that only the new stuff is shown Thanks, Smoky --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing two worksheets | Excel Worksheet Functions | |||
Comparing 2 worksheets | Excel Worksheet Functions | |||
Comparing worksheets | Excel Worksheet Functions | |||
Comparing two worksheets | Excel Discussion (Misc queries) | |||
Comparing Two Worksheets for changes | Excel Discussion (Misc queries) |