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

 

[Aberdham]

I just place your code there, it is probably at the wrong place.
so perhaps you could advise

 

[Fluff]

If you've put the code I supplied in the sheet module & it's not working, then please supply an updated workbook.

 

[Aberdham]

I have managed to get it working. Thank you so much Fluff!!

one question, the code "brings" me to that selection page, is it possible to "pull" the selection page to the "master" sheet?

 

[Fluff]

OK, 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
   Me.Range("17:" & Rows.Count).Clear
   If Not IsEmpty(Target) Then Sheets(CStr(Target.Value)).UsedRange.Copy Me.Range("A17")
End Sub

 

[Aberdham]

that works like a charm !!! Thank you so much !!

 

[Fluff]

You're welcome