Hi,
I think I have a very simple question, but after a lot of searching I have not been able to come up with a solution..
The problem I try to solve with a macro:
I have one cell that based on a lookup will return a certain column letter. If the cell return F, I want to copy data in F3:F7 in sheet 1, and if it returns G I want to copy data in G3:G7. The only thing that is dynamic is the column reference. So I need is to be able to insert the lookup value to the copy selection inside the macro.
Any help would be highly appreciated!
Thank you!
Bookmarks