I have a spreadsheet that requires massive updates and changes. I could do this using the replace function but that would still take a long time due to the number of changes that will be required.
What I need is a one click macro that will look at one column (A) and replace all occurances in the entire workbook (not just one sheet) exluding the reference sheet with the replace code that will be in column (B).
Old Code (A) New Code (B)
a - aa
b - bb
c - cc
d - dd
e - ee
f - ff
g - gg
h - hh
i - ii
j - jj
k - kk
l - ll
Hope this makes sense and someone can help. TY
Bookmarks