Linking workbooks
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? |
All times are GMT +1. The time now is 09:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com