I have many coordinators who fill out a long template with stat numbers.
(THey continue to update this template all year long and it contains each
month stats - so at the end of the year they have their entire years stats in
one document.) They email me their own workbook every month. I link them to
complete a year to date stats report. The problem I'm having is that it's a
big job setting up the links to total all the workbooks and I'm having to
redo the links every month. There has to be an easier way.

Any suggestions?

Hi Debbie

Maybe this is a start
http://www.rondebruin.nl/summary2.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Debbie" wrote in message ...
I have many coordinators who fill out a long template with stat numbers.
(THey continue to update this template all year long and it contains each
month stats - so at the end of the year they have their entire years stats in
one document.) They email me their own workbook every month. I link them to
complete a year to date stats report. The problem I'm having is that it's a
big job setting up the links to total all the workbooks and I'm having to
redo the links every month. There has to be an easier way.

Any suggestions?