| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
HELP 2sht comparison MACRO
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. |
|
#2
|
|||
|
|||
|
Could you not just use =Sheet!A1 in the first sheet and copy down?
-- HTH Bob Phillips "Les Wegg" wrote in message ... 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 | |||
| Macro and sub rountines | Excel Discussion (Misc queries) | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
| automatic macro update | Excel Worksheet Functions | |||
| Date macro | Excel Discussion (Misc queries) | |||
| Macro and If Statement | Excel Discussion (Misc queries) | |||
Linear Mode
