| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP 2sht comparision 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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HELP 2sht comparision Macro
See response in .misc
-- 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 | |||
| date comparision | Excel Discussion (Misc queries) | |||
| dates comparision | New Users to Excel | |||
| vlookup for more than two comparision | Excel Discussion (Misc queries) | |||
| Comparision formula | New Users to Excel | |||
| HELP 2sht comparison MACRO | Excel Discussion (Misc queries) | |||
Linear Mode
