Excel Macro Question?
Looking for a Find and replace macro that would replace values in a column with the column name.
I would need the macro to referance the column header name because there are 600 columns that need the values changed to the column header name the values are (1,2,3,4,5)
More Questions From This User See All
Answers & Comments
Verified answer
So it doesn't matter what's the the column -- you want it all replaced with the entry in the header? I must not understand this correctly, what do the values 1,2,3, 4,5 have to do with it?
And 600 columns -- that's rather a lot. What makes these columns different from the others?