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?