Reporting on multi worksheet spreadsheet

C

Cottamweb

I have a spreadsheet which calculates school term bills for children
attending a before and after school club dependent on their attendance
patterns. It also records payments which may be regular or intermittent and
calculates the amounts owed.

I have a worksheet for each child and up to now have manually referenced
each to create a summary report on another worksheet from which overall
totals and bad payers etc. can be derived. As the numbers are increasing is
there a simple way to assemble a summary sheet to create a list referencing
each individual childs worksheet ? All individuals sheets are formatted
exactly the same

For example

Sheet 1
Child - Jim Smith
Total Bill - £300
Total payments £200
Payment method - Cheque

Sheet 2
Child - John Brown
Total Bill - £200
Total payments £150
Payment method - Cash

Sheet 3
Child - Emma Patel
Total Bill - £100
Total payments £100
Payment method - E-Voucher

Summary
Sheet ID - Child - Bill - Payments - Type
Child1 Jim Smith 300 200 Ch
Child2 John Brown 200 150 Ca
Child3 Emma Patel 100 100 V
Total 600 450
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top