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