Linking each new Word Document to an Excel Spreadsheet

cnewton

New Member
Joined
Mar 30, 2013
Messages
1
I am not very experienced with Excel. Here is what I am attempting to accomplish. I am going to create a word document that can be filled in by users. Each time a user edits the word document and saves it under a different file name from the original, it automatically creates a new line in an Excel spreadsheet. The spreadsheet continues to populate as new word documents are saved. Users can then look at the Excel Spreadsheet, select files they would like to open and open the files through a hyperlink to the Word document. I'm not sure if this is even possible. I basically want a "table of contents" that acts as a file folder that links to each Word Document and automatically updates the "table of contents" as new files are saved. I do not want the users to be required to do any work with hyperlinks or Macros, I simply want them to save the file and the file automatically populate in an Excel Spreadsheet. Any help would be appreciated. Thanks!!!
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,516
Messages
5,837,789
Members
430,516
Latest member
thaling

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top