Merging/Appending Two or more Excel Files into one.

[achillese]

How do you merge two or more excel files with the SAME FILE STRUCTURES into one.

Everyday i receive excel files and usually cut and paste (append) this one into a master summary for the month with exactly the same columns. This become cumbersome since there are several files to cut and paste. Is there a way to do this in one go.

I tried in DOS prompt COPY *.XLS to MonthSummary.xls and it did not work.

Many thanks+++

 

[infinitelo]

2 ways come to mind

1 a program (vba or vb script)
This would be an easy program and you
may find that further process would be nice

2 use import external data
this is a good option if the original files
dont "go away" but will get slower and slower
over time.


if it is to be it's up to me

 

[achillese]

Unfortunately, I do not know vba.

Importing external data allows text file only and still requires manual manipulation. I was thinking of like a straightforward cut and paste...supposing the user is dumbed.

It would be good if you can provide the code for vb...

Thanks anyway...