Consolidating spreadsheets

G

Guest

Hello,

I am trying to consolidate 3 spreadsheets into 1. Each spreadsheet is in
table format.

The first spreadsheet is 'Asia, the 2nd 'Europe', the 3rd 'Americas'. I
would like the consolidated 4th spreadsheet to be a summary or an all
encompassing global view. Columns are the same.

Question - How can I create a function which brings in all Asia,Europe and
Americas information into one table format without previous knowledge of the
row count in each. The rows will be a variable in each spreadsheet.

Any help would be much appreciated.

Thanks
Acase
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Excel in Powerpoint 1
import data from several spreadsheets into one spreadsheet 2
Reference constant cells in different files from a master workbook 1
SQL Table Updates in VBA 3
consolidate multiple worksheets 13
linking between spreadsheets 5
VLookup multiple spreadsheets 2
Extracting data from hyperlinked spreadsheets 3

Top