I created an excel file for each manager in the department to enter monthly information, some of which is in text boxes within excel. I linked the text boxes to a monthly report word document by selecting around them and pasting special in word as a linked picture. But if I want to use the text in an annual report, I have to copy it out of the excel sheets each month and store it elsewhere so the managers can type the next month's information into that text box since the word document is linked to that specific text box.
Is there a better way to set up a monthly report that combines information from multiple excel workbooks, some of which information is freeform text?
Thank you!
Is there a better way to set up a monthly report that combines information from multiple excel workbooks, some of which information is freeform text?
Thank you!