Linking a running total on one spreadsheet to another spreadsheet

[MIXING]

I'm trying to link a series workbooks that use running totals. The columns in the first spreadsheet are side by side and titled Amount and Balance. Once the figure is entered in the "amount" column it changes the figure in the "balance" column. What I would like to do is create a link that updates the second spreadsheet as the figures entered in the "amount" column change the "balance" column in the first spreadsheet.

Thank you

 

[jason]

you can link one cell in sheet 2 to a corresponding cell in sheet1 by entering the following into the appropriate cell location in Sheet2:

=Sheet1!A1


if i enter this in B5 on Sheet2; whatever is in A1 on Sheet1 will also show in B5 on Sheet2

 

[remcos]

Alternatively, you can also type "=" in the cell on the first sheet, then click on the tabsheet you want the data from, and select the cell you want to display, rather than entering the formula manually.

 

[MIXING]

Thank you for your answers but I should've added more detail to my question. Sheet 1 keeps track of the budget and uses a running total so we know how much of the budget is left. On spreadsheet 1 the "Amount" column extends from E3 to E13 and the "Balance" column runs along side it (F3 to F13). The budget total is found in F1 of the "Balance" column and as figures are entered in the "amount" column cells it updates the "Balance" column along side it. The formula entered in F3 is =SUM(F1-E3), in F4 it is =SUM(F1-E4), etc. What I would like to do is create a link that updates a cell in a second spreadsheet as the totals are updated in the "Balance" column of the first spreadsheet. I'm trying to learn how to make a macro but I wanted to make sure that there isn't already a function in Excel for that.

Thank you

 

[Luke M]

Formula in other sheet would be:

='Sheet1'!F1-SUM('Sheet1'!E3:E13)


Or, you could do:

=MIN('Sheet1'!F3:F13)

which should get the same result.