Linking spreadsheets

[dgg9879]

At work I have several spreadsheets for adding cheques eg 5 cheques for
the Aquatic centre adds up to $100, 7 cheques for animal registration
adds to $200 etc. The spreadsheet adds the number of cheques and totals
automatically.

There is also a master spreadsheet to summarise all the totals. Instead
of showing the value of every cheque for the Aquatic Centre, it just
shows the number of cheques and the total, and so on,for all the
cheque categories and a master total for all cheques.

After I finish entering all the categories of cheques in individual
spreadsheets I enter them in for the master spreadsheet.

Please someone tell me if it is possible to link the individual
spreadsheets in with the master spreadsheet so that the master
spreadsheet is updated automatically as the individual spreadsheets are
updated. And most importantly, tell me how to do this!

I am Australian so you will have to excuse my spelling of cheque.

 

[Guest]

easy
on your master sheet in the cell for the total you want to show type = and
then click on the total cell from your other worksheet,and for the number of
cheques type= and click on the cel that shows the number of cheques.

 

[Guest]

If you modify your approach and enter all the cheques on a single tab,
structured along these lines

Col A - Date
Col B - Cheque amount
Col C - department

You can then generate Pivot tables off that data to summarize the data any
number of ways - by # of checks & totals department by date, by # of checks &
totals for a range of dates (i.e., weekly, monthly, etc)

Entering them all in a single place simplifies things and makes generating a
variety of reports SO MUCH easier

 

[Guest]

You can also select the cell that you have your formula in and do a copy then
go to the sheet you want to put the answer in and do a "special paste". this
will constantly update as you work on the original sheet.