Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation trouble
Thanks a lot John,
i have found another example and another way to achive this, but thanks again Regards "john" wrote: have a look at this site: http://www.contextures.com/xlDataVal02.html -- jb "copercar" wrote: Whant I'm trying to do is the following I have 3 columns with data 1 column contains Product type ex. coffe machines refrigerators ovens etc 2 column contains Product name ex coffe machine 1 coffe machine 2 coffe machine 3 refrigerator 1 refrigerator 2 etc 3 column contains Price for the items in column 2. My idea is to create this ex. In a blank worksheet in cell A1 to create data validation from 1 column, so when I'm choose coffe machine from that list, in cell B1 to list only products from column 2 related to the selection from A1 (it should be a list also in this cell), and after choosing coffe machine 1 in cell C1 to put price automaticly for choosen product. I suppose that this is possible but i don't know how to do it, so any help is welcome. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation trouble | Excel Programming | |||
custom data validation on cells with data validation values | Excel Worksheet Functions | |||
Crazy Data Validation ... List Validation Not Working | Excel Programming | |||
Trouble With Data Validation And Filtering On A Dropdown | Excel Worksheet Functions | |||
Trouble with validation | Excel Programming |