Produce a Word Document from Excel Macro Help

Hello Everybody,

Firstly, a massive thanks to everybody involved in this forum! I have recently joined after lurking for a couple of months and the information provided has been invaluable. This forum has made excel not as scary as it once was.

If anybody could help with my query I would be very grateful..

I have created a spreadsheet which allows me to keep track of products, when they were launched and last reviewed, along with their reference details.
Column H in my sheet changes colour depending on how long the review date is from the launch date of the product (6-11 months Amber, over 12 months Red)
Column D pulls information from a seperate workbook
The Command Button copies all rows which have a review date over a year from the launch (coded Red) into the second sheet called Results.

What I would like is for perhaps another command button which pulls the information from the Results Sheet into a Word Document, which I can use as a report, on a monthly basis, of which products have not been reviewed in over a year.

I have attached my spreadsheet to this post.

Everything I have done so far on the spreadsheet ive cobbled together from the information on this forum, but cant seem to find what i now require.

Thanks in advance.

This is great, thanks very much!

Is there any way I can set the formatting for how the information in Word should look? At the moment it seems like the spreadsheet is far too big for the Word page, and so it doesnt display correctly.

Once again, thanks for your time.