Hello,
Im trying to make a find and replace macro for multiple items. Please see the attached file for further explanation.
Hello,
Im trying to make a find and replace macro for multiple items. Please see the attached file for further explanation.
I could be looking at this to simply, but maybe:
![]()
Sub Macro_1() Range("C12") = 20200 Range("C13") = 20201 End Sub
Thanks for the reply,
THat is a little more simple than what im trying to do, I need the green hilighted numbers to stay the same and the code in the blue hilighted cells to change. Basically i need to refrence the value in c11 and find it in f12, m12 and p12, then replace it with the value in c12. This also needs to be done with row 13 (finding the c11 value and replacing it with whats in c13 for f13, m13 and p13. I hope my explanation is clear enough. Is this clear?
Oh I see...
![]()
Sub macro_1() Range("F12,M12,P12").Replace Range("C11"), Range("C12") Range("F13,M13,P13").Replace Range("C11"), Range("C13") End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks