entering formulas involving 2 workbooks

M

marysea

I have a workbook titled "weekly totals" and would like the final total to
appear in a workbook titled "monthly totals". Could anyone provide the
formula?
Thank you
 
B

BoniM

Open both workbooks, in the monthly totals workbook, click the cell where you
want the weekly total to be. type the equal sign, click the weekly totals
workbook and the cell that contains the total. Click the check mark on the
formula bar.
The formula will look like:
=[filename]sheetname!celladdress
you could type it, but it's way easier to click!
 
B

Bernard Liengme

Open the two files
In a cell in Monthly type =
Move to the Weekly file and click on the cell whose values is needed
Press enter
You will get a formula such as
='[Weekly Totals.xls]Sheet5'!$B$6
best wishes
 
Top