Can I store a pointer to a word file?

[Ausum]

I need a table to track tasks and work associated with the task. These can
get lengthy, and it would be helpful if the task or work items could reside
in word files, and then point to these from a cell. Can that be done?

 

[Bob I]

You mean like a Hyperlink to a Bookmark in the Word file?

 

[Kevin B]

You could use a hyperlink to point to the Word document. Click INSERT on the
menu, select HYPERLINK and browse until you locate the file you wish to link
to. Click the desired file in the directory tree and click the OK command
button to complete the link.

 

[Ausum]

Perfect! Thanks. I've been a "light" user of excel for a long time. The
"help" function had no responses to this, so appreciate your help! I tried
it and it works.

Ausum

 

[Ausum]

Sorry, I don't think I know how the "Bookmark" reference works. I went to
the hyperlink, and there was a "bookmark" button, but I didn't know what to
do with that. I was able to save a hyperlink, but not a bookmark. I'll work

 

[Bill Sharpe]

Perfect! Thanks. I've been a "light" user of excel for a long time. The
"help" function had no responses to this, so appreciate your help! I tried
it and it works.

Ausum

Excel help has a lot of information about hyperlinks, but if you look
for "pointers" you won't get much help, as you have discovered.

Bill

 

[Ausum]

Thanks Bill. I'll use hyperlink. My Microsoft vocabulary is obviously
deficient. Something else I need to address.

 

[Bob I]

Bookmarks are a "location" in a Word document, you may Hyperlink to
them. See Bookmark in Word Help.