I am wondering if there is a way to add a formula to my preexisting formula that will create a hyperlink to the corresponding worksheet.
In the example i provided my formula is in column C. The formula starts in cell C9 and returns the answers Day 1 - Day 6, salad bar, special meal, or a blank. I am wondering if there is a way to add a hyperlink to the formula in column C so that the end result will be a link to the corresponding worksheet as shown in column E.
Try
=HYPERLINK("#'" & C9 &"'!A1","DAY2")
in E9
Martin
a slight addition...
=HYPERLINK("#'" & C9 &"'!A1",C9)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
thanks that worked
Happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks