I have an Excel worksheet with data (A1-F1, A2-F2, A3-F3...etc) that has data I need to imported into a Word 2010 form/template (each cell data in a marked area on the form). It would be nice if I had a button on the spreadsheet that would initiate the process of Opening the Word doc, populate the form with data from that row, and print the form. The Excel spreadsheet is being updated on a constant basis as more assets arrive.
Currently I am cutting and pasting from Excel to Word doc and it is extremely time consuming. If I can automate the process I can share it with my co-workers that perform the same repetitive task.
Any ideas?
Bookmarks