How to merge several Excel Spreadsheets

[cohibaman]

I need to merge several Excel spreadsheets, all of similar format into a single spreadsheet. What is the best/recommednded practice to accomplish the merge?

Thanks

 

[xlbo]

SIMILAR format or IDENTICAL format ?? it does make a difference. Also, what kind of format ?? Lists of data or preformatted tables and charts ??

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[cohibaman]

Thanks Geoff for the speedy reply.The spreadsheets contain "similar" not "identical" formats of data lists.

 

[xlbo]

If they were identical, you could just copy and paste the lists one below each other - if there are differences, it will depend very much on what TYPE of differences.....just cell formatting or does different data appear in different places on the different files ??

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[cohibaman]

Is there another way to merge two or more "identical" excel spreadsheets other than the "cut n paste" method?

 

[xlbo]

Well, it can be easily automated - other than that, you could set up some append queries in access to append each worksheet in turn to 1 table and then export out but to be honest, the quickest way is gonna be to either do it manually or (if there are a lot of files) to write a bit of code that loops through and does the cut n paste for you

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[cohibaman]

I believe you're right in that the manual "cut n paste" process will perhaps be the best approach.

Thanks for you help! Have a great July 4th weekend.