Make link added to object dynamic based on worksheet name

Zedrick13

Board Regular
Joined
Sep 8, 2018
Messages
100
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'.
Step 1.png

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.
Step 2.png

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
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Watch MrExcel Video

Forum statistics

Threads
1,133,271
Messages
5,657,760
Members
418,411
Latest member
Excellency

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top