I have a named range ("replace_lookup") that has 2 columns: "from" and "to". I would like a macro that loops through the named range and replaces all values in column C of the "main" worksheet with the related "to" value. Can anyone help?
I have a named range ("replace_lookup") that has 2 columns: "from" and "to". I would like a macro that loops through the named range and replaces all values in column C of the "main" worksheet with the related "to" value. Can anyone help?
NVM, I think I've got it.
Please Login or Register to view this content.
Last edited by sugargenius; 01-10-2018 at 08:00 PM.
Or maybe just:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
That looks a lot more elegant than my solution. Can you explain how it works? It's not obvious to me how it searches every cell in column C and makes a replacement...
It just overwrites the column C value with the column B value - that seems to be what you're doing
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks