Currently I recieve status reports in MS Word format from multiple techs which I then manually combine into one status report (by copying and pasting) which I send to my supervisor. I would like to automate the process of combining these status reports. It's a pain.
Attached is an example of the form I would use to combine all of the individual tech status report. For the example I've put 2 items for each tech in each category but the number of items could be more or less than 2. Of course in each of the tech's status report only their name would be on the form (not the other techs).
What would be be best way of combining these status reports and can someone help show me how? I don't want to pay any licensing fees. Am open to all suggestions. Maybe a vb.net or vbs solution? STATUS-REPORT-TEMPLATE-EE.DOC