| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find and replace--Sort Of
I have a work sheet with data in columns B and C. I am wondering if there is
an automated way in which I can search for a certain value in Column B and based upon that field change the data in Column C? As in the sample below Column C data is not the same for the data listed in Column B, I need the macro or formula to search Column B for 4042 and change all entries in Column C to 25013, the same would be for 4054 and replace data in Column C to 25011. Any help would be appreciated. Column B C Manufact Part Number 4042 25013 4042 25014 4054 25011 4054 25011 4054 25011 4054 25011 4054 25013 4054 25021 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
| Sort (find / replace) by cell colour ? | Excel Discussion (Misc queries) | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| find replace cursor default to find box | Excel Discussion (Misc queries) | |||
![Joe[_9_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
