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


"dgg9879" wrote:


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: http://www.excelforum.com/member.php...o&userid=33489
View this thread: http://www.excelforum.com/showthread...hreadid=532895