G'day All,
I have an excel spreadsheet called 'Scenario Development' with the following sheets
- Front page
- Scenario Overview
- Scenario Scripting
- Apartment Building
- Cargo Ship
There will be more sheets soon.
What I want to do is have a Hyperlink on the 'Front Page' called "Virtual World Design" which will then go to the sheet that corresponds with the Text in 'Scenario Scripting'!J3
For example if 'Scenario Scripting'!J3' = "Apartment Building" then by clicking on the "Virtual World Design" link on the 'Front Page' then the 'Apartment Building' sheet opens up.
Hope this makes sense.
Thank you in advance.