Displaying data from one Excel doc in another

  • Thread starter Thread starter Nige
  • Start date Start date
N

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.
 
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
 
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
 
Nigel,
Have finally worked out
this is because my source cell is itself a formula destination cell.
Click to expand...

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

Nige said:
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


Nige said:
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.
Click to expand...
Click to expand...
 
Back
Top