Urgent Macro HELP required....Please...

[MGORIYA]

Good Afternoon Guys,

I have a small confusion..
I have more than 50 Excel files... that contains...Addresses for the employees of subcontracts.

Example...
Name Address1 Address2 City Mobile No. Joining Date Trade

My problem is the above field (Columns are not in above sequence in all files... majority file have odd sequence... what I need is, the macro idenfity the field that are not in a order and arrange in above order.

I hope my question make sense...
Please if any one can find solution, i would be very help full and much much time saving....its very urgent...

THanks in advance...

Mahiuddin

 

[Andrew Poulsom]

Can the files have columns with headers that are not in your list?

 

[Momentman]

50 different workbooks you mean?

how many worksheets in each of the workbooks contain the dat you might want to rearrange, is it always the first worksheet or a worksheet with a particular name in each workbook?

 

[MGORIYA]

Can the files have columns with headers that are not in your list?

Thanks for reply Mr. Andrew,

I do have colums header... like QS-001, QS-002.

etc..... but that are not in the order... like for example...

i have a file that contains data from QS-005 and QS-009, in column 3 and column 4 respectively, what i need is QS-005's data should go in column#5 i.e. E and data from QS-009's data go in column #9 i.e.Column I.

Hope this make sense...

Regards,

 

[Andrew Poulsom]

I don't see headings like QS-001 and QS-002 in your original post.