Importing Data From Another Spreadsheet

S

SamuelT

Hi all (again),

So, this continues on from my last query, hopefully in a slightly more
simplified manner.

Is there a means, beyond simply copying and pasting, of displaying a
number of rows and columns from one spreadsheet to another with the use
of a formula.

For example, in the spreadsheet 'Report Template', I want to display
A1:F20 from spreadsheets 'Report1', 'Report2' and 'Report3'. The
clincher, is that on some days I will not get sent 'Report2' (for
instance), but I still want to present the other two reports without
having a mass of blank cells in the middle. Is there a formula where I
can specify from which spreadsheet I want to display data from (as one
might using SUMPRODUCT, perhaps)?

Any ideas?

TIA,

SamuelT
 
S

SamuelT

Many thanks Max - not exactly what I was after, but I can use it, fo
sure!

Samuel
 
S

SamuelT

Hey Max (and any others),

With the formula above, what would I need to change for the informatio
to come from another spreadsheet (e.g. select cells A1:C30 in
spreadsheet named 'External Data') as opposed to simply anothe
worksheet within the same document?

TIA,

Samuel
 
Top