| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
search and replace data
In sheet1 cell A2 I have a ref number eg 1234567
I would like a macro to search through cells A12:A100 of sheet2 for the same ref number and when found replace the data in that row (columns A:O) with the data held in cells A2:O2 of sheet1 any ideas please? many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search and Replace, or Add New Row | Excel Discussion (Misc queries) | |||
| Macro - Search one book, replace with data from another | Excel Programming | |||
| How can I perform multiple search & replace - all data in spreadsheet? | Excel Programming | |||
| Problem with search and replace data,thanks for you help in advance. | Excel Discussion (Misc queries) | |||
| Excel VBA - Search And Replace Cell data | Excel Programming | |||
Threaded Mode
