![]() |
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