Linking information between workbooks

J

Jenny Potter

I have 3 Excel 2003 workbooks.
Workbook 1 - holds a number of worksheets. I have a worksheet called 'Home'
where client details are entered into specific cells (eg: Name, Client Code,
Year End date) and then it flows into the worksheets of each worksheet
contained within this workbook. This is all fine as I just have to use the
=Home!$F$4 function.
Workbook 2 - Client details needs to be linked from Workbook 1 ('Home'
worksheet) and automatically updated when Workbook 2 is opened. How do I do
this?
Workbook 3 - Client details need to be linked from Workbook 1 ('Home')
worksheet) and automatically updated when Workbook 3 is opened. How do I do
this?
 
P

Paul Sheppard

Jenny said:
I have 3 Excel 2003 workbooks.
Workbook 1 - holds a number of worksheets. I have a worksheet calle
'Home'
where client details are entered into specific cells (eg: Name, Clien
Code,
Year End date) and then it flows into the worksheets of each worksheet
contained within this workbook. This is all fine as I just have to us
the
=Home!$F$4 function.
Workbook 2 - Client details needs to be linked from Workbook 1 ('Home'
worksheet) and automatically updated when Workbook 2 is opened. How d
I do
this?
Workbook 3 - Client details need to be linked from Workbook 1 ('Home')
worksheet) and automatically updated when Workbook 3 is opened. How d
I do
this?
Click to expand...

Hi Jenny

Open workbook 1 and 2, in workbook 2 go to a cell you want to link t
workbook 1, type = in the cell and then go to workbook 1 and click o
the cell you want it to link to

Do the same for all cells you want a link, for both workbooks 2 &
 
Y

yh73090

Hi Paul,

Sorry I saw this post and it was pretty much what I was looking fo
with the exception of:

Will the link work if the receiving workbook is closed?

Thanks,

Yoland
 
Top