Hi. Does anyone know the VB code for:
Looking for a column header name, and then copying that column into a
separate worksheet.

i.e. On Sheet 1 -
look for column headers called "Part No", "Qty", "Description" and
"Cost". Then copy to Sheet 2 -
"Description", "Cost", "Qty" and "Part No"

You may ask why? I get various spreadsheets in different column
arrangements with more heading than described but the header names I
look for are always the same. This way I can "look" for a header name
and copy it into the correct order on another worksheet and use it
rather than manually search.

Any help would be much appreciated.

Adam


--
akane


------------------------------------------------------------------------
akane's Profile: http://www.excelforum.com/member.php...fo&userid=4273
View this thread: http://www.excelforum.com/showthread...hreadid=547253

Hi I googled this and found this you should be able to adapt it!

regards
Simon
http://www.rondebruin.nl/copy5.htm


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=547253

Hi Simon,

I can't decipher Ron's page. His one seems to create new sheets and
names the new worksheets accordingly.

Do you know any other methods (I'm not a VB guru either).

So just to clarify, when looking in a spreadsheet, I'm looking for a
couple of column header names, and then copying those columns only (in
a predefined order) into a clean separate worksheet.

i.e. On Sheet 1 -
Out of 30 column headers (with data underneath), look for column
headers called "Part No", "Qty", "Description" and "Cost". Then copy to
Sheet 2 -
"Description", "Cost", "Qty" and "Part No"

Thanks again.

Adam


--
akane


------------------------------------------------------------------------
akane's Profile: http://www.excelforum.com/member.php...fo&userid=4273
View this thread: http://www.excelforum.com/showthread...hreadid=547253

Ever find a solution to this?


--
drdavidge
------------------------------------------------------------------------
drdavidge's Profile: http://www.excelforum.com/member.php...o&userid=36168
View this thread: http://www.excelforum.com/showthread...hreadid=547253