In Progress

Create a Macro (Format spreadsheet, transfer to report format in Word)

I send out surveys in Survey Monkey and then download the raw excel data, format it and then copy it into an Excel template. I then take sections of the Excel and copy into Word to create a report. Each survey has 12 questions that are a mix of written response and “rank your answer on a scale from 1-10”. There are two Survey formats with two corresponding excel templates. The Word report template/format does not change. I would like to push a button and go from the raw excel data to a complete report in Word.

I estimate that this task would take 3-4 hours to complete a first pass, another hour to coordinate feedback with me and another 1-2 hours to complete the final product, or 7-8 hours total. From that I'd estimate approximately $200-$320 for the entire job. If you think my estimate is inaccurate I am open to discuss and negotiate.

I would like to have a working draft by Wednesday 10/17 to discuss with you, but have some flexibility. I have 3 reports that I am creating on Friday 10/19 that I would like to use this new macro for, which is the ultimate goal.

Skills: Excel, Excel Macros, Excel VBA, Visual Basic

See more: generate word document from excel macro, excel to word macro, how to transfer data from excel to word automatically, importing data from excel to word template, create word report from excel data, import data from excel into word automatically using vba, word macro examples, generate word document from excel data, vba macro generate report excel word, crystal report format formula, format prepare weekly report powerpoint, transfer pdf format, create macro email completed word document, macro code generate report excel word, transfer report word powerpoint, marketing roi report format, infineon test report format, free example roi report format, code transfer file format, monthly sales report format

About the Employer:
( 0 reviews ) San Diego, United States

Project ID: #17966931

Awarded to:

shoguna2m

Hello, my name is Andres. I have a great experience working in different projects involving Excel (macros, VBA, etc). I'm familiar with this type of requeriment. I belive I can help you within the timeframe (friday More

$280 USD in 4 days
(73 Reviews)
6.3

5 freelancers are bidding on average $246 for this job

elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega More

$300 USD in 5 days
(210 Reviews)
6.8
prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can build macro as u need, copy all data to your excel template and also generate output in word doc. please ping me for discuss detail of your project and im abl More

$300 USD in 3 days
(313 Reviews)
6.9
dataexplorer

Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional work More

$150 USD in 5 days
(12 Reviews)
3.3
lightingdavid

Hello. I have good skills in Excel/VBA. I have read your project description carefully and i can do it. Contact me please. Thanks.

$200 USD in 2 days
(6 Reviews)
3.3