My company wants seomthing in Excel which appears over my head and I was
wondering if someone could help. In this case we are using Excel as an index
to list all of our projects. In one column of the index is a hyperlink to
the Project Profile for that record/project. This Profile currently comes
from a Word template (can be transferred to Excel if it makes this process
easier)

We want the user to enter a new project, get to the hyperlink cell and by
selecting the cell hyperlink to a template that will be saved as a different
name (for this project) and then the new file name would be the hyperlink. .
So that the next time somone clicks on the hyperlink they get the profile
for this project NOT the template. The next new record would hyperlink to
the template and be saved as another name, etcIs there a way to do this?

Ultimately they would like all of the fields in Excel to populate the tables
in the Word file but this is WAAAY over my head so for now they will have to
re-enter.