ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Comparing data in two similar worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/11160-comparing-data-two-similar-worksheets.html)

HiRllr21

Comparing data in two similar worksheets
 
I have to compare data in two reports to find the differences. The report
has approx 15 columns and 2500 rows, and I need to extract each entry that
has changed since the previous report. Each entry has an ID#, that may or
may not have been in both reports, or is in both reports but has differing
data in some of the columns. I am relatively new to using excel, so any help
at all is appreciated.


All times are GMT +1. The time now is 07:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com