Reporting on multi worksheet spreadsheet
 

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

Reporting on multi worksheet spreadsheet
 

You need a key: Child's name v Sheet name
The it will be easy
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Cottamweb" wrote in message
...
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

Reporting on multi worksheet spreadsheet
 

I may have misspoke. Make a dummy workbook and send to me
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Cottamweb" wrote in message
...
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