Linking an Excel Snag List to the Comments in a Word File

prephil

New Member
Joined
Jan 20, 2019
Messages
5
Is it possible to link an Excel file to the comments being generated in a Word file? I have a situation at work where we have a Word document that is being used by several different people who are adding comments to it.

One of the guys is using an Excel file to create a snag list of issues based on these Word comments. I can understand why - it is very easy to see all the comments in one place line by line whereas Word is not so easy on the eye in this department, at least not in a way i know of.

So my question is, is it possible to link the Word & Excel files so that any comments that are entered in the Word file are automatically put into the Excel file. Anytime the Word file gets updated, i.e. new comments are added, the Excel file updates automatically also to show these new comments. An additional requirement, although not essential would be to have information like the page number the comment appears on in the Word file, auto arrange comments based on the page number they appear (could be filtered/arranged anyway based on page number), name of person who entered the comment, date of comment....
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
This is probably do-able, but if it was me I think I would just do the whole thing in Excel.
 

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
Well I've never done it myself so I can't give detailed instructions.
But when I used the search function on this board, using the terms EXCEL, WORD, LINK, FILES, it came up with lots of results, some of these may be helpful to you.

But seriously, consider doing it in just one package, either Excel or Word, not both, and I would definitely use Excel.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,658
Messages
5,573,447
Members
412,529
Latest member
cTatch
Top