I have created a macro that copies data from several different sheets into a worksheet and then sorts it alphabetically.
At this point though I am wondering if it would be possible to copy the data from this sheet into a new word document (with a prompt for the user to specify the word document name if possible?) and then run a macro in word to make sure the data is formatted correctly.
Is this at all possible?
Thanks in advance.
Bookmarks