Forum Discussion
VBA code to find and replace in each row based on cell value
Hi I need a VBA code that will cycle through a sheet and do the following. highlight the row and do a find and replace for that row, find the value in column B and replace with the value in column C...
Hi thank you for the suggestion but neither work. I am not looking for it to replace the value in column B, it need to search the row for the values in column b and replace with the value from column c. I have formulas in other cells in the row that need updating with the data
I don't understand. In the first post, you wrote "find the value in column B and replace with the value in column C for that row". I took that literally, but apparently you want something else. Please explain in detail and very clearly what you do want instead.
HansVogelaar effectively need it to do this:
and so on for each row..
there are formulas in rows e onwards that contain the text so need it updated.
Why would you want to replace 23010 with 2307111?
