Help to sort coloumns

Closed
SS - Sep 7, 2009 at 07:53 AM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Sep 7, 2009 at 09:04 AM
Hello,

I need help to write a macro that sorts coloumns in the user specified order

EG

WorkSheet 1 has 45 coloumns with headers like Customer, Name, Open Time, Status, Version etc... These values are in Range("A1:CA1")

I want to write a macro that searches for a text and moves it as the first coloumns.

For eg: If Cell1.value = "Customer" then this should be the first coloumn. Column 2 should be Status, Column 3 should be Open Time etc.

Please help/

1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Sep 7, 2009 at 09:04 AM
may be macro is not necessary
see the help "sort according to custom list"
1