Combining spreadsheets.

[patrick1967]

Hi all,

As always there are several solution to a problem so I am interested to see what others would do in the following situation:

Let's assume I have five spreadsheets with the same layout; the contents refers to different countries and I would like to add them all together in a new spreadsheet. So the overall spreadsheet will then start with all rows from spreadsheet one, immediately followed by all the rows from spreadsheet two, etc...
The spreadsheets are populated regularly so the contents, not the layout, will change.

What would be your suggestion to create the overall spreadsheet?

Thanks in advance.

 

[texasalynn]

the asap add-in has a function that does this and that's what I would use.

http://www.asap-utilities.com/