View Single Post
  #1   Report Post  
puneetarora_12
 
Posts: n/a
Default How to change drop down values based on another cell value?


My query is as follows:
I want to change the drop down values in cell B1, based on the value
entered in cell A1. The drop down values in B1 should dynamically
change as A1 is changed.

The range of drop down values allowed for a value of A1 will be stored
in another sheet (for e.g.)

Please help.


Thanks !

Puneet Arora


--
puneetarora_12
------------------------------------------------------------------------
puneetarora_12's Profile: http://www.excelforum.com/member.php...o&userid=18406
View this thread: http://www.excelforum.com/showthread...hreadid=473257