Link to home
Start Free TrialLog in
Avatar of Brent
BrentFlag for United States of America

asked on

Edit Hyper Links

I am building stats sheet for my kids basketball team.
I am trying to set it up so every year it is easy just to change the "info" tab and then updates the entire workbook.

One area I am having trouble with is my hyperlink to each worksheet. Since there are so many worksheet, I want a quick and easy way to get to each game (about 15 games).

Is there a way to make the hyperlink easily editable. Or am I just stuck with showing her how to change the hyper link the next year?

Thanks
Brent
callie-workbook-VER-4.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Slow fingers :)
Avatar of Brent

ASKER

I was able to add the hyper link with no problems. I was thinking more along the lines of next year how she will be able to change it as the schedule changes.

thanks
bvanscoy678,

>>I was able to add the hyper link with no problems. I was thinking more along the lines of next year how she
>>will be able to change it as the schedule changes.

My comment above shows how to use formulas to make your hyperlinks dynamic.  Please have a look.

Patrick
Avatar of Brent

ASKER

Okay,

I will read it over again.
Brent,

I am glad that you got the help you needed.  The points are nice and all, but what really motivates me are the "thank yous" from the people I help.

My apologies for kind of hijacking your thread.  It's just that plagiarism and copyright infringement are two things EE takes very seriously, and where it happens it needs to be addressed.

Patrick
Avatar of Brent

ASKER

Patrick,

Please do not be concerned about hijacking a thread. I was able to benefit from your post and there is always something for someone to learn
in the additional post.

Thanks for the help. As always, greatly appreciated.

Brent
Thank you for your assistance, Vee_Mod!

Patrick