software

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.--
dgg9879
------------------------------------------------------------------------
dgg9879's Profile: www.excelforum.com/member.php...oamp;userid=33489
View this thread: www.excelforum.com/showthread...hreadid=532895easy
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.
--
paul

remove nospam for email addy!
quot;dgg9879quot; wrote:

gt;
gt; At work I have several spreadsheets for adding cheques eg 5 cheques for
gt; the Aquatic centre adds up to $100, 7 cheques for animal registration
gt; adds to $200 etc. The spreadsheet adds the number of cheques and totals
gt; automatically.
gt;
gt; There is also a master spreadsheet to summarise all the totals. Instead
gt; of showing the value of every cheque for the Aquatic Centre, it just
gt; shows the number of cheques and the total, and so on,for all the
gt; cheque categories and a master total for all cheques.
gt;
gt; After I finish entering all the categories of cheques in individual
gt; spreadsheets I enter them in for the master spreadsheet.
gt;
gt; Please someone tell me if it is possible to link the individual
gt; spreadsheets in with the master spreadsheet so that the master
gt; spreadsheet is updated automatically as the individual spreadsheets are
gt; updated. And most importantly, tell me how to do this!
gt;
gt; I am Australian so you will have to excuse my spelling of cheque.
gt;
gt;
gt; --
gt; dgg9879
gt; ------------------------------------------------------------------------
gt; dgg9879's Profile: www.excelforum.com/member.php...oamp;userid=33489
gt; View this thread: www.excelforum.com/showthread...hreadid=532895
gt;
gt;

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 amp; totals department by date, by # of checks amp;
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 easierquot;dgg9879quot; wrote:

gt;
gt; At work I have several spreadsheets for adding cheques eg 5 cheques for
gt; the Aquatic centre adds up to $100, 7 cheques for animal registration
gt; adds to $200 etc. The spreadsheet adds the number of cheques and totals
gt; automatically.
gt;
gt; There is also a master spreadsheet to summarise all the totals. Instead
gt; of showing the value of every cheque for the Aquatic Centre, it just
gt; shows the number of cheques and the total, and so on,for all the
gt; cheque categories and a master total for all cheques.
gt;
gt; After I finish entering all the categories of cheques in individual
gt; spreadsheets I enter them in for the master spreadsheet.
gt;
gt; Please someone tell me if it is possible to link the individual
gt; spreadsheets in with the master spreadsheet so that the master
gt; spreadsheet is updated automatically as the individual spreadsheets are
gt; updated. And most importantly, tell me how to do this!
gt;
gt; I am Australian so you will have to excuse my spelling of cheque.
gt;
gt;
gt; --
gt; dgg9879
gt; ------------------------------------------------------------------------
gt; dgg9879's Profile: www.excelforum.com/member.php...oamp;userid=33489
gt; View this thread: www.excelforum.com/showthread...hreadid=532895
gt;
gt;

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 quot;special pastequot;. this
will constantly update as you work on the original sheet.

quot;dgg9879quot; wrote:

gt;
gt; At work I have several spreadsheets for adding cheques eg 5 cheques for
gt; the Aquatic centre adds up to $100, 7 cheques for animal registration
gt; adds to $200 etc. The spreadsheet adds the number of cheques and totals
gt; automatically.
gt;
gt; There is also a master spreadsheet to summarise all the totals. Instead
gt; of showing the value of every cheque for the Aquatic Centre, it just
gt; shows the number of cheques and the total, and so on,for all the
gt; cheque categories and a master total for all cheques.
gt;
gt; After I finish entering all the categories of cheques in individual
gt; spreadsheets I enter them in for the master spreadsheet.
gt;
gt; Please someone tell me if it is possible to link the individual
gt; spreadsheets in with the master spreadsheet so that the master
gt; spreadsheet is updated automatically as the individual spreadsheets are
gt; updated. And most importantly, tell me how to do this!
gt;
gt; I am Australian so you will have to excuse my spelling of cheque.
gt;
gt;
gt; --
gt; dgg9879
gt; ------------------------------------------------------------------------
gt; dgg9879's Profile: www.excelforum.com/member.php...oamp;userid=33489
gt; View this thread: www.excelforum.com/showthread...hreadid=532895
gt;
gt;