Hello,
Cross-posted at MREXCEL - COULD NOT PASTE LINK
Cross-posted at chandoo.org - COULD NOT PASTE LINK
Cross-posted at OZGRID - COULD NOT PASTE LINK
I have a VBA macro that will insert a new column (titled updated col..) to the right of the specified column name. Then I use a VLOOKUP and autofill in the new column to provide the updated values. The column location of the updated column is variable/dynamic. How can I make the autofill function automatically perform in the column range lu or in the adjacent column?
I tried to write it like this
My current solution requires manually inputting the column Letter location everytime before running the VBA
Bookmarks