Displaying data from one Excel doc in another

[Nige]

Hi all.

This must be easy, but it's defeating me. I have created two Excel
documents, each with multiple pages. I wish to display the info from one
cell on the first document in a cell on the second, and have tried linking
them with the = sign etc, but this is coming up as an error.

My thimbleful of Excel knowledge is now exhausted and I'm stumped. Can
anyone help?

Many thanks,

Nigel.

P.S. As usual, apologies if this has recently been dealt with. I tried a
Google Groups search but couldn't find it.

 

[Anders S]

Nigel,

Try this:
- in the destination cell, enter "=" without the quotes. Do *not* press Enter
- switch to the other workbook and select the source cell. Press Enter.

That's it, you should get a formula like

=[Book1]Sheet1!$A$2

HTH
Anders Silvén

 

[Nige]

Many thanks for replying Anders.

Have tried exactly what you suggest, but itomes up with an error ("A value
used in the formula is of the wrong data type"). Have finally worked out
this is because my source cell is itself a formula destination cell. So I
copied the info from that cell to a blank cell and made that my new source
cell, then follwed your instructions and all is well.

Thanks again,

Nigel.


Nigel,

Try this:
- in the destination cell, enter "=" without the quotes. Do *not* press
Enter
- switch to the other workbook and select the source cell. Press Enter.

That's it, you should get a formula like

=[Book1]Sheet1!$A$2

HTH
Anders Silvén

 

[Anders S]

Nigel,

Have finally worked out
this is because my source cell is itself a formula destination cell.

It should work anyway with a formula in the source cell. The formula
=[Book1]Sheet1!$A$2
works fine for me with a formula in A2.

What is the formula in your source cell?

Anders

Many thanks for replying Anders.

Have tried exactly what you suggest, but itomes up with an error ("A value
used in the formula is of the wrong data type"). Have finally worked out
this is because my source cell is itself a formula destination cell. So I
copied the info from that cell to a blank cell and made that my new source
cell, then follwed your instructions and all is well.

Thanks again,

Nigel.


Nigel,

Try this:
- in the destination cell, enter "=" without the quotes. Do *not* press
Enter
- switch to the other workbook and select the source cell. Press Enter.

That's it, you should get a formula like

=[Book1]Sheet1!$A$2

HTH
Anders Silvén

Hi all.

This must be easy, but it's defeating me. I have created two Excel
documents, each with multiple pages. I wish to display the info from one
cell on the first document in a cell on the second, and have tried linking
them with the = sign etc, but this is coming up as an error.

My thimbleful of Excel knowledge is now exhausted and I'm stumped. Can
anyone help?

Many thanks,

Nigel.

P.S. As usual, apologies if this has recently been dealt with. I tried a
Google Groups search but couldn't find it.