Macro to find a header based on a value in another cell
I'm looking for some help writing a vba macro to find header with a name that is equal to another cell, then copy the entire column to a new column to the right. The value I want to find will be in the header row in cells (F2-Q2) and the value I am looking for can be found in cell V1. Once the header is found, copy the entire column and paste in column AG.
I've attached an example worksheet. I appreciate any help you can provide!
|