Capturing data

[Charlie Brown]

I am working on a registration form for a meeting. I currently have a sheet
set up as a registration form with cells for various fees to be paid by the
registrant. My current plan is to use a seperate sheet for each registrant
(approx 100 - 150) all within the same workbook.

The question is: What would be the best way to summarize the various
amounts paid and the numbers of people registered for each event all onto
one sheet? I looked at using a Pivot Table, but apparently my data on the
registration form is not arranged correctly. I have been looking at using a
summary sheet within the same workbook, but have not been able to come up
with a formula that will add up the numbers from all of the sheets.

Thanks for any help.

Charlie

 

[Gord Dibben]

You will be much happier and life will be easier if you have everything on one
sheet.

Then the filtering, sorting, grouping, subtotalling and PivotTable functions are
simpler to use.


Gord Dibben MS Excel MVP