ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to Compare Rows on 2 shts .... (https://www.excelbanter.com/excel-discussion-misc-queries/25660-how-compare-rows-2-shts.html)

Les Wegg

How to Compare Rows on 2 shts ....
 
I have 2shts, one with old data, one with new (Changes, Adds, Deletes)
The Rows could be as many as 10 columns wide and the rows may not be in any
particular order. I require some code to take the first row in sht.2 and
look for it in sht.1 and tell me if it has changed (C) or is added (A) a
column may be added to depict the Changes, Adds, Deletes.






All times are GMT +1. The time now is 05:16 PM.

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