Arranging columns by name (non-alphabetic order)

[mylovelyhorse]

Hi,

I have a spreadsheet with 30 columns and around 2,500 rows per column. The columns are an extract from a SharePoint instance and are not in the order I need them to be in for my purposes (import into another system).

I have a macro that prepares the data with various actions, including echoing a previously recorded cut & paste actions, something like this:

Please Login or Register  to view this content.

... however I think that's a bit rubbish and not nearly as efficient as it could be. It certainly slows my laptop down when it's running!

I'd prefer to have a way of listing the column names in the desired order and some VBA to sort the columns into that order. That would hopefully give me the flexibility to easily amend the order &/or number of columns by adding or subtracting column names from the list embedded in the VBA. Er, if that makes sense.

Can anyone help me?

Cheers

M

[venkat1926]

suppose columns names are like this below (of course it can be sorsted alphatically forget about it)
see the numbers given in row 2
sort (left to right) whole data according to row 2 and you can then delete row 2

[venkat1926]

suppose columns names are like this below (of course it can be sorsted alphatically forget about it)
see the numbers given in row 2
sort (left to right) whole data according to row 2 and you can then delete row 2

a s f d g
1 5 3 2 4