Data Validation

[Aberdham]

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?)

 

[oldbrewer]

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.....

 

[Aberdham]

Thank you for your quick response.

Does that work as the drop down list ?

 

[Fluff]

How about

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

 

[Aberdham]

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?

 

[Fluff]

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.

 

[Aberdham]

Still couldn't get it to work.

Could you please make a demonstration in this file:

https://onedrive.live.com/view.aspx...=file,xlsx&app=Excel&authkey=!AEsto0Qrdr_HWHQ

thank you !

 

[Fluff]

That's an xlsx file, you need to save the workbook as an xlsm, for macros to work

 

[Aberdham]

I have saved as xlsm and run the code. It is still not working.

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

 

[Fluff]

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"