Re: Excel two independent lists?
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
How did you create the lists?
You could use data validation to create dropdown lists in two cells, and
select a different value in each cell. There are instructions in Excel's
Help, and here:
http://www.contextures.com/xlDataVal01.html
mirkobonet@xxxxxxxxx wrote:
I've created two lists, but when I select a value in one the other
opens and viceversa. I'd like to create two independent lists where
both stay close showing me only the value I select.
Thanks
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
.
Relevant Pages
- Re: unlocked cells in excel 2000 now locked when opened in 2003 wh
... your assumption was correct the cells are locked in 2000 ... > data validation dropdown, if the list is from a range on the worksheet. ... > In Excel 2002 and later versions, neither type of dropdown list can be ... >> allowed to select entries from validated lists in unlocked cells. ...
(microsoft.public.excel.misc) - Re: How can I use a named range for "pick from drop-down list"?
... dropdown cells and engage "Pick from drop down list", ... "Doug Evans " wrote: ... >> Data Validation dropdown lists don't support autocomplete. ... >> which you can select one of the values from the data validation list. ...
(microsoft.public.excel.misc) - Data Validation preventing ISTEXT() from reading FALSE in 97
... I have a series of cells in my worksheet that are villed by DATA VALIDATION ... lists. ... Help, my spreadsheet works, but it looks ugly. ...
(microsoft.public.excel.misc) - Re: How to use a macro to change the selected item in data validat
... there will be cells where one can select a option ... cells countaining the drop-down lists back to "Please Select". ... Change, selectionchange, doubleclick, etc. ...
(microsoft.public.excel.misc) - Re: How to use a macro to change the selected item in data validat
... the file is safe, with only one macro. ... there will be cells where one can select a option ... cells countaining the drop-down lists back to "Please Select". ... Change, selectionchange, doubleclick, etc. ...
(microsoft.public.excel.misc) |
|
