Hi There!
I know there is a much better way to transfer my data from a word document to excel, rather than re-keying in the data, especially since all of the data is already given and no changes need to be made to the excel document.
I will be given an excel document from a different area at work, and I need to populate in an existing word fax document to notify others. The excel data will have multiple tabs, but the majority of information is on the main sheet, and the data needed to populate the word document will always be coming from the same excel cell location into the location noted in the word document.
I'm assuming I can do this with a macro, but I'm not too familiar with defining my variables in excel, so anything to get me started would be so extremely helpful - I've attached an example of the formats/design of the documents.. (I had attempted to look at the mail merge function, but that wasn't doing the trick).
Thanks again!