Dynamically changing the input range of a Drop Down

  • Thread starter Thread starter DoctorV
  • Start date Start date
D

DoctorV

I have a drop down in Excel on a sheet named Level 2 Support Tea
Member. Based on the value of a prior dropdown results for this are i
Cell H8 I need the Input Range to change dynamically

Example If H8 =1 the Input range should be Sheet1!$B$2:$B$10
If H8=2 the the Input range should be Sheet1!$c$2:$c$10
And Finally IfH8=3 the the Input range should be Sheet1!$d$2:$d$10

What do I need to do to dynamically change this InputRange? Name o
Control is Drop Down 5
Thank
 
Back
Top