If a cell is not black, take data from another cell and automatically link to a Word doc.

[cory_0101]

I have an Excel template and I need to somehow link it to a Word template. After a user enters all of the necessary data into the Excel sheet, I would like the proper data to populate into a Word document. Three columns in Excel we will say are column B, C, and D. If column D is marked with an X, put cell data from column B, and C into the Word document. There could be multiple rows of data that are getting added to the Word document, but not all of them will have an X in column D so need a way to prevent white space as well. Any thoughts on the most efficient way to handle this?


Header edit " If cell is not blank, copy two other cells in that row to a list in a Word Doc"
Thanks ahead of time.

Cory