Linking information between workbooks
 

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?

Jenny Potter Wrote:
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?

Hi Jenny

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

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


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=399386