Hi All,

So basically this is my problem, thousands of MSWord Comment sheets have been raised on a design task. It is now my job to collate these into one long list within Excel...I know this could take forever copy and pasting, so I was looking for some help...

The Word Document (Comment sheet) has within it a Table which is divided into 5 columns, there are as many rows as there are total comments (i.e. this number is variable depending on the number of comments).

I would like to create a macro to copy the information (the comment) from the word file (comment sheet) into an excel spreadsheet, then repeat this for the remaining 1999 documents

Many thanks!
ryan