I'm trying to figure out how to open expand a grouping of related items using a hyperlink. As you can see from the attached screenshot, I've got the following game items grouped under the main title:
"Batman Arkham Knight Premium Edition". There are 3 such groups (each with different names). At the bottom of the sheet, I've got a summary of all the game related items.
In cell B700, I have "Batman Arkham Knight Premium Edition (34 DLCs)" with a hyperlink that goes to the 1st named item within the grouping. The hyperlink takes me to the named range, but it does not expand the list. Is there any way to expand it using a hyperlink? If not, I'm open other ideas that might be more effective. Thanks.
"Batman Arkham Knight Premium Edition". There are 3 such groups (each with different names). At the bottom of the sheet, I've got a summary of all the game related items.
In cell B700, I have "Batman Arkham Knight Premium Edition (34 DLCs)" with a hyperlink that goes to the 1st named item within the grouping. The hyperlink takes me to the named range, but it does not expand the list. Is there any way to expand it using a hyperlink? If not, I'm open other ideas that might be more effective. Thanks.
