What does your template in Word look like? Can it easily be
transferred into an Excel sheet? If it can, then you can have a series
of hyperlinks in a Contents sheet, which allows you to jump to the
appropriate sheet for each project (I'm thinking that the sheets would
be contained within the one file - is it important that they are
separate files, and if so, would they all be saved within the same
folder?)

Pete

On Oct 22, 2:44 pm, JICDB wrote:
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.