Hi Excel Gurus,
I am seeking help with a VBA Code. I am learning VBA, but I hit a roadblock.
I would like to copy and paste special columns containing a specific Text String at the top (see picture). I would like to do the copy and paste action on the same sheet and I would like the code to scan the entire sheet for the Text string "Paste". As you see in the picture I have the Text String "Paste" in row 1 column D. I would like to run a code that Copy and Paste special the column where "Paste" Text String is. The Text String will be in row 1 and column D through Z or cell D1 to Z1.
In advance, thank you so much for your help!
I am seeking help with a VBA Code. I am learning VBA, but I hit a roadblock.
I would like to copy and paste special columns containing a specific Text String at the top (see picture). I would like to do the copy and paste action on the same sheet and I would like the code to scan the entire sheet for the Text string "Paste". As you see in the picture I have the Text String "Paste" in row 1 column D. I would like to run a code that Copy and Paste special the column where "Paste" Text String is. The Text String will be in row 1 and column D through Z or cell D1 to Z1.
In advance, thank you so much for your help!