Hey all, Joined up as I am in need of some help figuring out how someone else made a Tab Naming formula work without loosing hyperlinks to a main summary sheet. The individual who made the Workbook I have been modifying to suit the company I work for needs; that said - I have significantly modified many of the formulas within the cells themselves but - cannot for the life of me figure out how to utilize this feature in the version I have now created based off of his original work.
Any help would be greatly appreciated and, if at all possible - I would rather stay away from VBA coding.
Here is the formula he utilized:
=HYPERLINK("#Item2",'Item #2'!B6)
This formula would allow for the user to change the tab names to whatever they wished wish is a feature very much desired.
After user entry that same hyperlink would allow for something like this
=HYPERLINK("#Item2",'User Entry Whatever'!B6)
His workbook also had a feature where when holding the cursor over the hyperlink cell on the summary sheet it states
Item2 - click once to follow. click and hold to select this cell.
Thanks in advance and I'm hopeful the Hive Mind might lend a hand with this request.
MrE
Any help would be greatly appreciated and, if at all possible - I would rather stay away from VBA coding.
Here is the formula he utilized:
=HYPERLINK("#Item2",'Item #2'!B6)
This formula would allow for the user to change the tab names to whatever they wished wish is a feature very much desired.
After user entry that same hyperlink would allow for something like this
=HYPERLINK("#Item2",'User Entry Whatever'!B6)
His workbook also had a feature where when holding the cursor over the hyperlink cell on the summary sheet it states
Item2 - click once to follow. click and hold to select this cell.
Thanks in advance and I'm hopeful the Hive Mind might lend a hand with this request.
MrE
