Copy all columns that contain a value in the header

Microsoft Excel 2003 (full product)
April 18, 2012 at 18:15:14
Specs: Windows XP
This question has been partially answered here: http://www.computing.net/answers/of...

This macro copies the first column that contains value 'x', but I would like to copy all instances and paste them into a new worksheet in Excel (2003). I think I need a loop to do this.


See More: Copy all columns that contain a value in the header

Report •

#1
April 18, 2012 at 19:10:21
Since you have 2003 you have a great Help file example of how to use .Find and .FindNext. For some reason they removed the example in 2007 and beyond.

Click on .Find in the VBA editor and hit F1 to bring up the Help file. Copy the example into the VBA editor and modify it to suit your needs.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
April 19, 2012 at 06:44:33
Thanks, DerbyDad03. I will give it a shot.

Report •
Related Solutions


Ask Question