macro VBA Help

[gerv19]

I am new to VBA and using Macros. I need to write a code that will take the following excel template and create a word document out of it. The excel file has 7 different sheets in total that I will somehow need to all pile into one single code to spit out a neater word document. The image below is the cover sheet. How can I make a code that lets the customer fill out the yellow highlighted areas all while looking neat in a word doc? Also having the same table layout below presented in the word doc as well? Is this even possible?

PLEASE HELP!!

thank you

 

[gerv19]

The picture is not uploading correctly. Contact me if you think you will be able to help and I will send you the file.

 

[hiker95]

The picture is not uploading correctly. Contact me if you think you will be able to help and I will send you the file.

gerv19,

Welcome to the MrExcel forum.

Please see Rule #4, at the next link:

https://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[hiker95]

The picture is not uploading correctly.

gerv19,

We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data (sensitive data changed), and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729



If you are not able to provide screenshots, then:

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com