Help - Organizing Multiple Columns

Hello,

i have data in rows and columns mixed for example Sl no. went lat but one column, name in last column, and Location is in first so kindly help me to organize data. as this is very less rows and columns i can do manually. but i will be generating large data where i will be having more than 50 columns that time will be difficult to organize. let me know if there any code or trick to do by selecting titles like Sl no, Code, Name should show accordingly.

Example:

Loc-5 code-2 desig-4 Sl no-1 name-3
KA 501 tech 1 aaa
TN 503 sol 2 ccc
AP 502 hr 3 ddd
KL 504 payrol 4 bbb

in above example, columns are mixed list Sl no. went lat but one row. what i need is Sl No. should be in 1st Column, Code should be in 2nd Column, Name should be in 3rd Column, Desig should be in 4th column, Loc should be in 5th Column.

attached excel for your reference. excel help.xlsx

appreciated your help.

Thnx
Sree

kindly help on above question...

Pl find the attached File with macro .Macro arranges all the columns as per the column number available in the end of heading.

@ Srinivasa Murthy- thnx it works.
but i have large data like more than 50 rows, every row i hve to search and put numbers at end of a cell may take long time.
m also looking for any easyest way.

thnx
sree

Then in which order you want the heading row. It should be available in some row or column.