Hi All,

In Excel I have 15 columns which each contain dynamic lists that show filepaths to word documents. For example, Column 8 may have 8 cells each containing a filepath, column B may have 3 cells containing file paths etc...The number of cells in each column is going to be variable - i.e. column A might have 8 entries today, but 9 tomorrow.

I would like to create a VBA script in Excel to take each of the filepaths and paste the contents at a specified bookmark in word. Each of the 8 filepaths in column A would paste to 'bookmark1', Each of the three filepaths in column B would paste to 'bookmark2'.

If it helps, in the Excel sheet the first filepath entry in each column is in row 8.

Any help would be greatly appreciated!!