| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching for a value for and then replacing when found.
Can someone tell me how I would do the following:
- I have numbers in cells E5:E10; A1 and B1 - I would like to search for A1 in cells E5:E10 - On the first instance I find of A1, I would like to replace the value of that cell with B1 What would be a simple way to write this? Thanks, Fish |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replacing ? | Excel Worksheet Functions | |||
| Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
| searching names for '*', replacing it with first name | Excel Programming | |||
| Cell searching and Replacing | Excel Discussion (Misc queries) | |||
| Help Replacing all ( * ) with ( - ) | Excel Discussion (Misc queries) | |||
Threaded Mode
