Hi,
At work every evening we need to create a report of the day's productivity and activity, about 15 minutes is spent just copying the data already spread across various sheets on an excel document into an email to all the staff, and i was thinking there must be a way to make this easier, by somehow linking this data from excel into fields in a word document, which can then be used as a template for the day report.
I need various conditions to be met.
- Firstly, i want it to basically go into a "template" sort of structure, so the numbers from excel would need to go in as if they were typed text (i.e. not in any form that couldnt be copied into an email program) for example it would be "Todays productivity was held at [would need to insert a designated excel cell here, i.e. 85%]
- Secondly the excel file this would be coming with is set up with hyperlinks (which appear to be hidden, but i believe just link through to different sheets in the workbook, so different sheets would need to be accounted for (i.e. the specific location of the cells would need to be specified)
-And finally, this may be the most challenging.... the excel file the data would be coming from is a new one each week (i.e. we'll have one outlining the plans and final data for each day at the start of each week). They are all the exact same template each week, from the same core file i'd imagine, but just with different numbers in the fields to reflect the plans for that week. Whilst i was thinking the above would be feasible, would the fact that it would be a different file name each week mean if i were to link all the cells to a word document.... would i have to do this all over again? Or would there be a way of basically telling word to look for those cells in the file called "week commencing 21/10/13.xls" instead of the previous week's "week commencing 14/10/13.xls"
Your help is greatly appreciated!
Bookmarks