What goes in each of the seven worksheets...
Sheet 1: Text, typed in manually
Sheet 2: The table of deliverables. The table and the check marks are entered manually
Sheet 3: Text table, lines added manually
Sheet 4: Text table, lines added manually
Sheet 5: 3 Circle graphs, data entered manually and then the corresponding graph is created
Sheet 6: Bar graph, data entered manually
Sheet 7: Bar graph, data entered manually
What the relationships are between the sheets...
None, each sheet is it's own and not related to another. Each represents a small section of the final 3 page word document report.
Where the data in Word might go or how it is to be formatted there.
The data makes up one 3-page report. As of now, there is no real formatting. Each graph or table is copied from Excel and pasted into Word and therefore becomes nothing more but a picture.
My goal...
I would like to created a template in Word with a corresponding Excel page in which the PM can enter the data and then run a macro or VBA script that moves the data from Excel to Word. Attached is an example of the document.
I hope I worded that correctly. I am obviously not exceptionally skilled or experienced at this type of work.
Thanks again!
|