Linking workbooks

#1 March 23rd, 2005, 11:13 PM

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?

#2 March 23rd, 2005, 11:26 PM

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Linking Workbooks	Dede McEachern	Worksheet Functions	0	January 21st, 2005 08:27 PM
Linking Between Workbooks - Errors in Preservation	Vanessa	General Discussion	0	September 8th, 2004 07:38 PM
Linking Workbooks	Jasmine	Worksheet Functions	4	April 28th, 2004 09:09 PM
Linking workbooks	Keith Blazek	Setting up and Configuration	0	February 4th, 2004 04:57 PM
Linking workbooks with sorted data	Jason	Worksheet Functions	3	November 3rd, 2003 08:08 PM