The subject essentialy is what I want to accomplish. Also if when I update
the tabs (rename or add a new one) the list of hyperlinks adjusts
automatically? If it needs to work the other way around that would be ok as
well. (hyperlink edits result in tab name edits and/or additional tabs)
thanks for the help!

The best way to create an internal hyperlink (to another place in the
workbook) is to assign a Name to the destination and hyperlink to that Name.


Then you can change tab names and all will be o.k.
--
Gary''s Student - gsnu200746


"excel-chump" wrote:

> The subject essentialy is what I want to accomplish. Also if when I update
> the tabs (rename or add a new one) the list of hyperlinks adjusts
> automatically? If it needs to work the other way around that would be ok as
> well. (hyperlink edits result in tab name edits and/or additional tabs)
> thanks for the help!

Gary''s Student,
It took me a little while to figure out how to get it to work the way I
needed it to (not for how you explained it but for my own lack of
inderstanding in Excel) work, but I got it working great now! Thank you so
much for giving me direction.

excel-chump

"Gary''s Student" wrote:

> The best way to create an internal hyperlink (to another place in the
> workbook) is to assign a Name to the destination and hyperlink to that Name.
>
>
> Then you can change tab names and all will be o.k.
> --
> Gary''s Student - gsnu200746
>
>
> "excel-chump" wrote:
>
> > The subject essentialy is what I want to accomplish. Also if when I update
> > the tabs (rename or add a new one) the list of hyperlinks adjusts
> > automatically? If it needs to work the other way around that would be ok as
> > well. (hyperlink edits result in tab name edits and/or additional tabs)
> > thanks for the help!