| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Question. (oops...sorry)
I have data validation set up for a few cells in my spreadsheet. What
I am trying to do is create a secondary list based on the selection from the first cell. EXAMPLE. Category Fruit Vegetable Fruit Apple Pear Grape Vegetable Potato Snow Pea Squash In the first cell containing data validation (Say A10) you chose Fruit or Vegetable. In cell B10 your drop down options are based on what is entered in A10. A10=Fruit, choices on B10 are Apple Pear or Grape, whereas if A10=Vegetable, your choices on B10 are Potato, Snow Pea or Squash. I have checked out http://www.contextures.on.ca/xlDataVal02.html and can't seem to figure it out. Can anyone help? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation Question. (oops...sorry)
See http://www.contextures.com/xlDataVal02.html
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ChuckF" wrote in message oups.com... I have data validation set up for a few cells in my spreadsheet. What I am trying to do is create a secondary list based on the selection from the first cell. EXAMPLE. Category Fruit Vegetable Fruit Apple Pear Grape Vegetable Potato Snow Pea Squash In the first cell containing data validation (Say A10) you chose Fruit or Vegetable. In cell B10 your drop down options are based on what is entered in A10. A10=Fruit, choices on B10 are Apple Pear or Grape, whereas if A10=Vegetable, your choices on B10 are Potato, Snow Pea or Squash. I have checked out http://www.contextures.on.ca/xlDataVal02.html and can't seem to figure it out. Can anyone help? Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation Question. (oops...sorry)
Chuck
I doubt if you will get a better explanation than you get at Debra's site. What part(s) don't you understand? The range naming or the INDIRECT? Read it over a few times and I think you can get it figured out. Debra also has some sample workbooks for download. See this site........ http://www.contextures.on.ca/excelfiles.html#DataVal Gord Dibben MS Excel MVP On 11 Sep 2006 10:35:15 -0700, "ChuckF" wrote: I have data validation set up for a few cells in my spreadsheet. What I am trying to do is create a secondary list based on the selection from the first cell. EXAMPLE. Category Fruit Vegetable Fruit Apple Pear Grape Vegetable Potato Snow Pea Squash In the first cell containing data validation (Say A10) you chose Fruit or Vegetable. In cell B10 your drop down options are based on what is entered in A10. A10=Fruit, choices on B10 are Apple Pear or Grape, whereas if A10=Vegetable, your choices on B10 are Potato, Snow Pea or Squash. I have checked out http://www.contextures.on.ca/xlDataVal02.html and can't seem to figure it out. Can anyone help? Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation Question. (oops...sorry)
Hi Chuck
If you have followed Debra's instructions and defined your named ranges correctly, then with Data Validation set up in cell B10 as List, with source =INDIRECT(A10) then it should work. What happens when you do it? -- Regards Roger Govier "ChuckF" wrote in message oups.com... I have data validation set up for a few cells in my spreadsheet. What I am trying to do is create a secondary list based on the selection from the first cell. EXAMPLE. Category Fruit Vegetable Fruit Apple Pear Grape Vegetable Potato Snow Pea Squash In the first cell containing data validation (Say A10) you chose Fruit or Vegetable. In cell B10 your drop down options are based on what is entered in A10. A10=Fruit, choices on B10 are Apple Pear or Grape, whereas if A10=Vegetable, your choices on B10 are Potato, Snow Pea or Squash. I have checked out http://www.contextures.on.ca/xlDataVal02.html and can't seem to figure it out. Can anyone help? Thanks! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation Question. (oops...sorry)
oops, didn't follow it to the end and see that he had already seen it :-(
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Chuck I doubt if you will get a better explanation than you get at Debra's site. What part(s) don't you understand? The range naming or the INDIRECT? Read it over a few times and I think you can get it figured out. Debra also has some sample workbooks for download. See this site........ http://www.contextures.on.ca/excelfiles.html#DataVal Gord Dibben MS Excel MVP On 11 Sep 2006 10:35:15 -0700, "ChuckF" wrote: I have data validation set up for a few cells in my spreadsheet. What I am trying to do is create a secondary list based on the selection from the first cell. EXAMPLE. Category Fruit Vegetable Fruit Apple Pear Grape Vegetable Potato Snow Pea Squash In the first cell containing data validation (Say A10) you chose Fruit or Vegetable. In cell B10 your drop down options are based on what is entered in A10. A10=Fruit, choices on B10 are Apple Pear or Grape, whereas if A10=Vegetable, your choices on B10 are Potato, Snow Pea or Squash. I have checked out http://www.contextures.on.ca/xlDataVal02.html and can't seem to figure it out. Can anyone help? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro question | Excel Worksheet Functions | |||
| Data validation with hyperlinks | Excel Worksheet Functions | |||
| Case Sensitivity problem with data validation | Excel Worksheet Functions | |||
| Data validation question | New Users to Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
