| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
| How do I compare similar rows of data in same worksheet | Excel Worksheet Functions | |||
| Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
Linear Mode
