Excel database creates a Word document from a template based on excel data

Hi All,

I would like to create a Macro that I can attached to a button that will allow me to create a new Word document (.docx) from a template (.dotx), which will automatically enter to last detail of a cell in a column into a specified location of the word document.

The idea is that the Excel document will hold a ledger of Quotes, from that document we can create a new quote (based on Word), with the Quote number already inserted.

If it is too complicated to look at the last entry maybe we could create the quote based upon the information from the selected cell.

Any assistance would be greatly appreciated, from my research so far I believe the this is nigh on impossible as a formula, however it should be relatively easy as a macro.