Consolidate the data in 4 Excel files

[ramakrishnan_1731]

Dear Experts,

I have 4 different excel files containing similar type of data where as the column headers are of different sequence. I want to join the 4 files into one file where datas are arranged
accordingly. Pls help with a soultion.

Regards
R.Ramakrishnan

 

[ravishankar]

Hi
Please tell us how many sheets of data, how many rows and columns of data you have and how do you propose to arrange them in the masterbook.
Ravi

 

[ramakrishnan_1731]

Single sheet in 4 wook book. But colums headers are in different sequence

 

[ramakrishnan_1731]

please any body help

nobody answered my question.