Excel Project - Sharing
Hi everyone,
I am designing an excel project for a company which has several different geographical locations (sites). Each site has a seperate workbook which are identical to each other, and at each site the employees fill in (update) with their own data, which is calculated and certain reports and charts are created. One of the requirements is that the director of the company would like be able to see these reports and charts for every site for his own use from his own location. He would only be vieiwng this at least once a month. I am having trouble decideing how i should go about this. The workbooks themselves are quite large in size so would be impractical to send the whole thing to him from each site. Any and all ideas are welcome. If you need any more information please ask. Regards Nick |
Excel Project - Sharing
The director should decide what data he needs to see from each site and have
it prepared in a summary format. It should be easy enough to extract the information from each site copy and compile it into a single report for the director. "nickm687" wrote: Hi everyone, I am designing an excel project for a company which has several different geographical locations (sites). Each site has a seperate workbook which are identical to each other, and at each site the employees fill in (update) with their own data, which is calculated and certain reports and charts are created. One of the requirements is that the director of the company would like be able to see these reports and charts for every site for his own use from his own location. He would only be vieiwng this at least once a month. I am having trouble decideing how i should go about this. The workbooks themselves are quite large in size so would be impractical to send the whole thing to him from each site. Any and all ideas are welcome. If you need any more information please ask. Regards Nick |
All times are GMT +1. The time now is 01:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com