Data Validation

Aberdham

Board Regular
Joined
Mar 8, 2018
Messages
163
Office Version
  1. 365
Platform
  1. Windows
Hi,

I have got a data set with multiple sheets, each represents an identical course number.

I am wondering if there is a way that I could select from the drop down list in the "master" sheet and have the sheet pop up by the selection value.

here is a link to my sheet:

https://1drv.ms/x/s!Aqt4VfikFsyKgRlLLaNEK3a_x1h0

Thank you in advance.

(NB: within those sheets, those rate/discount factor are implemented to calculate the pv, so each period is different, is there an alternative to get the average rate within a period?)
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
a hyper link will take you to say cell A1 on the desired sheet and on that sheet another hyperlink could take you back to the master sheet.....
 
Upvote 0
Thank you for your quick response.

Does that work as the drop down list ?
 
Upvote 0
How about
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.CountLarge > 1 Then Exit Sub
   If Target.Address <> "$D$6" Then Exit Sub
   If Not IsEmpty(Target) Then Sheets(CStr(Target.Value)).Activate
End Sub
This needs to go in the sheet module for Master
 
Upvote 0
Hi Fluff,

Thanks for your answer.

How do you mean sheet module?

I inserted a module and tried this macro, but it return as I need to give this macro a name?
 
Upvote 0
It needs to go in the sheet module, not a regular module.
Right click on the tab "Master" > view code > paste the code into the window that opens up.
 
Upvote 0
That's an xlsx file, you need to save the workbook as an xlsm, for macros to work
 
Upvote 0
Firstly, it doesn't work because you have put it in the wrong place. Please see post#6
Secondly, the code that is in the file has absolutely nothing to do with your question in this thread.
Therefore I'm not surprised that "It's still not working" ;)
 
Upvote 0

Forum statistics

Threads
1,213,558
Messages
6,114,297
Members
448,564
Latest member
ED38

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
Back
Top