• We are receiving reports of members using the private messaging service (Conversations) in ways that break the forum rules:
    • Do not invite another member to take the question off the forum (i.e. do not suggest that they post to a different forum, do not suggest that they email or private message you the problem, do not simply post a link to another forum, unless it is to a specific, relevant, thread). This applies equally to members asking or answering questions.
    • Soliciting business for yourself is not permitted. This is an all volunteer board, so offering solutions in exchange for compensation is not permitted. Likewise, members seeking solutions must not offer compensation for them. If you have an urgent need, check the Consulting Services page.
    Please help us out by clicking the Report link on any messages you receive that violate these rules. Thank you
  • If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
    If you forgot your password, you can reset your password.

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

prephil

New Member
Joined
Jan 20, 2019
Messages
4
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....
 

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.
 

Forum statistics

Threads
1,077,965
Messages
5,337,441
Members
399,147
Latest member
Raviteja KOTHA

Some videos you may like

This Week's Hot Topics

Top