| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Data Validation
Hi, Does anybody know whether you can have Excel make a Data Validation List based on a previous Data Validation List? That is if I select x in A1 (as part of a DVL which consists of x,y,z,etc), that a DVL in B1 is created with values x1,x2,x3, etc).. Thanks, that save me a lot of work ;-) Peter -- Peter1999 ------------------------------------------------------------------------ Peter1999's Profile: http://www.excelforum.com/member.php...o&userid=33997 View this thread: http://www.excelforum.com/showthread...hreadid=538459 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Data Validation
Check out this page of Debra Dalgleish on the subject of dependant lists:
http://www.contextures.com/xlDataVal02.html -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Peter1999" wrote in message ... Hi, Does anybody know whether you can have Excel make a Data Validation List based on a previous Data Validation List? That is if I select x in A1 (as part of a DVL which consists of x,y,z,etc), that a DVL in B1 is created with values x1,x2,x3, etc).. Thanks, that save me a lot of work ;-) Peter -- Peter1999 ------------------------------------------------------------------------ Peter1999's Profile: http://www.excelforum.com/member.php...o&userid=33997 View this thread: http://www.excelforum.com/showthread...hreadid=538459 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Data Validation
Thanks for replying, RagDyer, but using this method I could only use entries in A1:A100 that have only one word. As the data is complicated and the file has to be user friendly, I will have to be able to use multiple words. If anybody has tips, thanks a lot, Peter -- Peter1999 ------------------------------------------------------------------------ Peter1999's Profile: http://www.excelforum.com/member.php...o&userid=33997 View this thread: http://www.excelforum.com/showthread...hreadid=538459 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Data Validation
When you opened the link I gave you, right at the top of the page, didn't
you see a list of additional links that Debra provided for including various types of data in your lists? -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "Peter1999" wrote in message ... Thanks for replying, RagDyer, but using this method I could only use entries in A1:A100 that have only one word. As the data is complicated and the file has to be user friendly, I will have to be able to use multiple words. If anybody has tips, thanks a lot, Peter -- Peter1999 ------------------------------------------------------------------------ Peter1999's Profile: http://www.excelforum.com/member.php...o&userid=33997 View this thread: http://www.excelforum.com/showthread...hreadid=538459 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering and Data Validation | Excel Discussion (Misc queries) | |||
| Data Validation | Excel Discussion (Misc queries) | |||
| Loading Column Data with blank Rows into Data Validation Box | Excel Worksheet Functions | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Data Validation | Excel Discussion (Misc queries) | |||
Hybrid Mode
