Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 5th 05, 03:28 AM
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


  #2   Report Post  
Old October 5th 05, 04:14 AM
Debra Dalgleish
 
Posts: n/a
Default

You can create dependent data validation lists. There are instructions
he

http://www.contextures.com/xlDataVal02.html


puneetarora_12 wrote:
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.)




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #3   Report Post  
Old October 5th 05, 05:15 AM
Dan
 
Posts: n/a
Default

Step as follow:
Create 2 drop-down list (A1, A2) which you would like to have reference to.
Data-Validation

e.g. On Sheet1, A1, which is referring to Sheet1,"B1:B10"
e.g. On Sheet1, A2, which is referring to Sheet2,"A1:A10"

Write VBA for with private sub "Worksheet_SelectionChange" which check if
the target cells is A1. If yes, refresh the list on Sheet2. The
drop-downlist will refresh value inside automatically.

"puneetarora_12" wrote:


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


  #4   Report Post  
Old October 5th 05, 11:28 AM
paul
 
Posts: n/a
Default

i can email you a small sample sheet which uses vlookup and match to do this
with comboboxes from the forms toolbar
--
paul
remove nospam for email addy!



"puneetarora_12" wrote:


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




Reply
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 05:13 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017