Hello Everyone,
I'm a referee and solving different cases each time with mathematical calculations in excel. I have created all the sentences and tables in excel and then copy/paste my findings into my word report file.
I have a specific directory for each case in which I keep my related excel and word files.
I wanted to know that how can I automatically export my sentences from excel to word's related location.
For example:
I have an excel file named as case001.xlsx and there are certain cells with text info such as in sheet1: A1, B77, C5 in sheet2: D5
Then I want to have a word template in which I will define and locate case001.xlsx and it will automatically create the following report:
I.INTRODUCTION
case001.xlsx!sheet1!A1
II. THE CASE
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Maecenas porttitor congue massa. Fusce posuere, magna sed pulvinar ultricies, purus lectus malesuada libero, sit amet commodo magna eros quis urna.
case001.xlsx!sheet1!B77
case001.xlsx!sheet2!D5
III. RESULT
case001.xlsx!sheet1!C5
I will appreciate any help!
Thank you very much.
Bookmarks