Hi everyone,
I hope someone could help me with this query.
I am working on a file with a 'Summary' worksheet with a table that lists all other worksheet names present within the workbook (see screenshot below). On one of the other worksheets (VCNA.PIV1), I've added a grouped object (see screenshot below), 2 shapes consisting of an arrow and rectangle with text, which a link could be added and when clicked takes the user to the 'Summary' worksheet. When this VCNA.PIV1 is copied and renamed, it could still do the same action but could only point at the same cell reference (e.g., A1 of Summary worksheet) unless manually changed.
Link to file: Sample File - Dynamic Object Link Query.xlsx
I will be working on a lot of worksheets and would rely on copying one of the worksheets and renaming them manually. I want to know is if there is a way to make the link to the object group dynamic without using VBA. I am hoping to achieve the outcome described below:
1. Worksheet 'VCNA.PIV1' is copied and renamed as 'VCNA.PIV4'.
2. When a user clicks on 'Back to Summary', it takes the user to the 'Summary' worksheet and the cell within the table with the value matching the worksheet name (VCNA.PIV4) is selected.
3. Get the same result when the same set of actions above are performed for other new worksheets.
MS Excel Version: Office 365
Version 2103 (Build 13901.20400)
Thanks,
Zed
I hope someone could help me with this query.
I am working on a file with a 'Summary' worksheet with a table that lists all other worksheet names present within the workbook (see screenshot below). On one of the other worksheets (VCNA.PIV1), I've added a grouped object (see screenshot below), 2 shapes consisting of an arrow and rectangle with text, which a link could be added and when clicked takes the user to the 'Summary' worksheet. When this VCNA.PIV1 is copied and renamed, it could still do the same action but could only point at the same cell reference (e.g., A1 of Summary worksheet) unless manually changed.
Link to file: Sample File - Dynamic Object Link Query.xlsx
I will be working on a lot of worksheets and would rely on copying one of the worksheets and renaming them manually. I want to know is if there is a way to make the link to the object group dynamic without using VBA. I am hoping to achieve the outcome described below:
1. Worksheet 'VCNA.PIV1' is copied and renamed as 'VCNA.PIV4'.
2. When a user clicks on 'Back to Summary', it takes the user to the 'Summary' worksheet and the cell within the table with the value matching the worksheet name (VCNA.PIV4) is selected.
3. Get the same result when the same set of actions above are performed for other new worksheets.
MS Excel Version: Office 365
Version 2103 (Build 13901.20400)
Thanks,
Zed
