Work book formulas

[Guest]

I have two Excel work books.

Work book A will be updated on a weekly basis and show hours worked.
I want work book B to show the total from work book A. I would also like
work book B to update from work book A everytime it is opened.

Any ideas?

 

[Guest]

Hi Jessica,

You should open both workbooks and in workbook B select the cell which will
show the total from workbook A. Then type = in the cell and go to workbook A
and select the values to be summed. Go back to workbook B and correct the
formula (e.g. =SUM ([Book1]Sheet1!$B$2:$C$13)). Then go to Edit-> Links ...
and change the settings if neccessary.

Hope this helps.

Peter