Hi all,

A Friday task to end the week off on a good note.

So I have an Excel file with hundreds of rows where the row headings are as follows:

A1 - No.
B1 - Category
C1 - Question
D1 - Answer

For each row I would like to be able to create a single word document so that I have a one-pager record.

The excel rows will grow over time so the the otion to select the range would be ideal so that I can individually select the new rows as and when they get created. Also would be nice to be able to ADD headings should I need to at some stage.

So I think this involves creating a Word template with Bookmarks and then a macro in Excel but for the examples I have found I simply cannot seems to get anything to work.

Anybody up to this Friday task?

Kind regards :-)