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