Merge Excel files

[Balas]

Hi -

Could any one in the forum help me to merge 2 excel files.

Thanks in advance.



Balas

[macropod]

You'll need to provide a lot more detail than that. With what you've posted, all I could suggest is copying data from one to the other.

[Balas]

Lets start into the details-

Consider there are 3 Ms Excel 2007 files. I.e,

1 Student file
2 Department File
3 Teachers file

Student file in turn contains more than 10 sheets, each sheet contains particular information about the student like, student's age and demographic information, Previous education, Parents education status etc.

Department file contains more than 10 sheets, each sheet contains specific information like department details in 2002, department details in 2003, department details in 2004 etc.

Teacher's file contains more than 10 sheets, each sheets in turn contains specific information of the teachers.

We needs to prepare a single excel file with the name my_school details.

Copying the data is a tedious task, any ways every one can do that. But, I need to know how can we merge all these files to a single file???

Kindly let me know whether we can achieve this MS Excel?

Thanks,
Balas

[macropod]

Hi Balas,

Yes, you can put all those worksheets into a single file. The simplest method is to open the one with the most worksheets, then cut & paste the worksheets from the other workbooks into it. Unless you have a very great quantity to do, it would probably take less time to do it manually than to write code to automate it. And, if it's a once-off exercise, the effort involved in developing the code probably wouldn't be worthwhile.

What you should be considering is moving away from Excel to a database like Access.

[Pecoflyer]

This add-in has helped me a lot