= Formula for other spreadsheets

[Quinton]

Hello I have 2 spreadsheets:

Spreadsheet 1 - Where all the data is stored
Spreadsheet 2 - Where I want to copy some data on Spreadsheet 1

I used the = command but I get the #value! The formula is shown below:

='[Site Flow Chart - Staple Chambers.xlsx]Flowchart'!$E$40:$G$40

I believe the problem is that it is trying to = a range of cells as the data is merged into 3 cells.

Any ideas would be much appreciated?

Many thanks in advance.

Quinton

 

[VoG]

Does this work?

='[Site Flow Chart - Staple Chambers.xlsx]Flowchart'!$E$40

 

[Quinton]

Doh!

Many thanks - I should have thought of that 1!

Cheers,