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...
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?
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.
Are the dates sorted in ascending order?
- yes they are