software

I just created a simple worksheet to total volunteer hours that help with
band boosters. It then occurred to me that I could build a workbook that
contains a worksheet for each volunteer, and a summary page with sub-totals
and total hours.

It's very easy to do get a total of the hours across all the worksheets, but
I'm having difficulty figuring out how to have the summary sheet contain a
simple list of each volunteers name and their hours, without manually having
to add references to the name on each worksheet, and their related time.

I would like it to be as automatic as possible. I'm thinking the ability to
do an absolute reference to a worksheet might do the trick, but I can't
figure out how to do that, or come up with any other way to automatically
populate a summary page with names and a value from each worksheet..

Any ideas or suggestions?

Hi Tom

You can try
www.rondebruin.nl/summary.htm--
Regards Ron de Bruin
www.rondebruin.nlquot;Tomquot; gt; wrote in message ...
gt;I just created a simple worksheet to total volunteer hours that help with
gt; band boosters. It then occurred to me that I could build a workbook that
gt; contains a worksheet for each volunteer, and a summary page with sub-totals
gt; and total hours.
gt;
gt; It's very easy to do get a total of the hours across all the worksheets, but
gt; I'm having difficulty figuring out how to have the summary sheet contain a
gt; simple list of each volunteers name and their hours, without manually having
gt; to add references to the name on each worksheet, and their related time.
gt;
gt; I would like it to be as automatic as possible. I'm thinking the ability to
gt; do an absolute reference to a worksheet might do the trick, but I can't
gt; figure out how to do that, or come up with any other way to automatically
gt; populate a summary page with names and a value from each worksheet..
gt;
gt; Any ideas or suggestions?