Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
writing a macro for search-match-copy
I need help writing a macro that will copy data from E2.Sht1 to E2.Sht2 if
A2.Sht1 = A2.Sht2, but it needs to be able to search all cells in column A.Sht1 for a match to the data in A2.Sht2, for each row in Sht2. both lists are extensive (ie: over 3000 cells in a column). I need this for work. I'm using Excel 2003. I also need to be able to understand what i'm writing so that I can explain it to those that come after me. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Search and Copy | Excel Discussion (Misc queries) | |||
Writing A Search Macro With Wildcard Characters? | Excel Programming | |||
Search and copy macro | Excel Programming | |||
search/copy/paste macro | Excel Programming | |||
Search/copy/paste Macro | Excel Programming |