Enhance an Excel Macro
- or -
Post a project like this2234
£10(approx. $13)
- Posted:
- Proposals: 13
- Remote
- #1916786
- Completed
Description
Experience Level: Intermediate
I have created a psychometric report that runs in excel and word. Essentially it works like this:
- Users complete an online questionnaire
- I upload this data into an excel spreadsheet i've created
- The spreadsheet runs a range of analysis
- The results are then linked to a word document
- I then save these documents and send back to the user
I've created a macro (attached) that allows me to automate parts of the this process. At the moment i can copy the data from the online form into excel, press one button, and it creates all of the word docs for each row, and saves them as worddoc1.doc, worddoc2.doc, worddoc3.doc and so on...
Basically I just want to automate two more steps of this process:
1. I want the documents to save with the user's name, contained within a cell in the spreadsheet. e.g. worddoc joe bloggs.doc, worddoc jane bloggs.doc etc.
2. I also want to create a PDF copy of the document that i can send to users
- Users complete an online questionnaire
- I upload this data into an excel spreadsheet i've created
- The spreadsheet runs a range of analysis
- The results are then linked to a word document
- I then save these documents and send back to the user
I've created a macro (attached) that allows me to automate parts of the this process. At the moment i can copy the data from the online form into excel, press one button, and it creates all of the word docs for each row, and saves them as worddoc1.doc, worddoc2.doc, worddoc3.doc and so on...
Basically I just want to automate two more steps of this process:
1. I want the documents to save with the user's name, contained within a cell in the spreadsheet. e.g. worddoc joe bloggs.doc, worddoc jane bloggs.doc etc.
2. I also want to create a PDF copy of the document that i can send to users
Matt S.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
50%
Last project
13 Mar 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies