automatically import data from a cell in oneworkbook to another workbook

[Karshish]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel How do arrange for workbook A to import the data from a cell in workbook B? In other words, what formula (address?) should I enter in a cell in workbook A so that it will import the data in a cell from workbook B?

 

[Mungo]

This would be just another formula; start with =+ and then just use the mouse/trackpad to click on the referenced cell (assuming you have both wordbooks open. Be careful of relative/absolute references.

 

[Karshish]

Thanks, Mungo

Cheers

Karshish

 

[John McGhie]

1) Make sure both workbooks have been saved to disk.

2) Select the cell in Workbook B and COPY

3) Select the cell where you want it in Workbook A

4) Edit>Paste Special>Paste Link...

Excel will write the formula for you!

Cheers

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel How
do arrange for workbook A to import the data from a cell in workbook B? In
other words, what formula (address?) should I enter in a cell in workbook A so
that it will import the data in a cell from workbook B?

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

--

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]