LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Resetting values based on change in cells of other column NSteinner Excel Discussion (Misc queries) 1 September 4th 05 04:09 PM
is it possible to select and change the values of cells in a minimized excel spread sheet from vba? Daniel Excel Worksheet Functions 6 July 11th 05 11:24 PM
Change font size in drop down validation lists Big Daddy Excel Discussion (Misc queries) 2 February 3rd 05 05:22 PM
Modify Row & Cell Contents based upon Cells Values bpat1434 Excel Worksheet Functions 1 November 6th 04 05:17 PM
How do I change the appearance of my drop down lists? Tom Tanner Excel Worksheet Functions 1 October 28th 04 04:03 PM


All times are GMT +1. The time now is 08:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"