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
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