Word Document Output from Excel Sheet

I am in the process of setting up an excel spreadsheet where you select various check boxes (in order to select what product you want). At the end of selecting all of your options a price will be created as well as some text with information regarding what options for the product you have selected. Once all of the data has been decided I would like to make it so you can either click a button and a word document will be produced with all of the information regarding your options you selected or have a word document set up that can be opened and all of the information from the excel spreadsheet with be populated in the word document. I am pretty new to using vba, so any advice regarding linking word documents and excel spreadsheets would be appreciated.

Thank you.

Originally Posted by meabrams

If you could post sample excel file and word doc so that we have a better idea of how you want this to look

I am currently having issues with getting the documents to upload, but here is a general idea of what the spreadsheet looks like:

Customer Name John Smith
Company Name Inc
Date 12.09.2017

Item Options 1 Price
Choice 1 5
Choice 2 10
Choice 3 15

Item Options 2
Choice 1.2 20
Choice 2.2 25
Choice 3.2 30

Total 105 (I'm going to have this total set up so it only includes the numbers where the check boxes have been selected)

And this is generally what the word document looks like:

PRODUCT OUTPUT SHEET
Customer Name
Company
Date

Item Options 1
Choice # Description Price

Item Options 2
Choice # Description Price

Quotation information:
Price €