Forum Discussion

Copper Contributor

Jul 27, 2023

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...

Macros and VBA

JamesPhImp

Copper Contributor

Jul 27, 2023

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

HansVogelaar

MVP

Jul 27, 2023

JamesPhImp

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.

JamesPhImp
Copper Contributor
Jul 27, 2023
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.
- HansVogelaar
  MVP
  Jul 27, 2023
  JamesPhImp
  
  Why would you want to replace 23010 with 2307111?
  - JamesPhImp
    Copper Contributor
    Jul 28, 2023
    HansVogelaar Apologies the screenshot had a typo, should be 230711. Each day links to a new file with a date format YYMMDD and we update once a month or less, so I don't want to have to go and do 30+ different find and replace functions manually and unfortunately the indirect formula means opening each file to link to a dynamic file name as far as I am aware.