Hi
I have a userform that looks up data from sheet 1 and shows it in a simple userform
I need to update the details if they are incorrect and replace them in the cells that they were found in
The code I am using is:
Basically, if I find the details required and they are in cell G3 & I3 & L3, and the details are wrong, I can overwrite the data on the userform, click the ok button and they will replace the data in said cells. Likewise if the data was found in any cell number from the columns stated above.
Really not sure where the code is going wrong as it finds the data, but will not replace it
Bookmarks