| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MACRO Wanted to compare Rows of 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 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 | |||
| Repeating rows not wanted | Excel Worksheet Functions | |||
| Removing rows not wanted... | Excel Discussion (Misc queries) | |||
| How to Compare Rows on 2 shts .... | Excel Discussion (Misc queries) | |||
| Macro to align & compare multiple columns with several rows | Excel Programming | |||
| Macro to align and compare multiple rows and columns | New Users to Excel | |||
Linear Mode
