Link monthly balance to summary spreadsheet

[John Smith]

I run a spreadsheet detailing a rent account, 1 column per month. I would
like to link the monthly balance into a cell within my financial summary
spreadsheet. Is it possible? Please keep answer simple as I am a novice.
Many Thanks

 

[Janusz Pawlinka]

I run a spreadsheet detailing a rent account, 1 column per month. I would
like to link the monthly balance into a cell within my financial summary
spreadsheet. Is it possible? Please keep answer simple as I am a novice.
Many Thanks

If you have monthly balance and summary in two separate *.xls files
you can link in this way:

file1.xls - name of file (monthly balance)
sheet1 - name of worksheet in this file
c2 - cell with value


in desired cell in file2.xls (financial summary) you can type

=[file1.xls]sheet1!c2

this works when both *.xls files are in the same computer directory.
If not, you should type full path to file1.xls like this:

='c:\my_documents\excel\monthly_ballance\[file1.xls]sheet1'!c2

I hope this will help