| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation based on data to left but several columns dependen
I have a document that has has validation/name ranges, e.g., in column A I
have a dropdown choice of Apples/Oranges; in column B, if I have chosen Oranges in column A, I want the choices in column B to be Valencia/Blood, etc.; if I chose Apples in column A, then I want the column B choices to be Gala/Delicious, etc. It works currently with an =indirect(A1) as the formula in B1; however, I now want to expand to columns C, D, etc., so that if I have chosen Gala in B1, then I have choices in column C, and on and on. HELP! Thanks! Marv Lusk Boise Corporation |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data Validation based on data to left but several columns dependen
Debra Dalgleish's site:
http://www.contextures.com/tiptech.html go down to the "D's" and under Data validation, find dependent dropdown. -- Regards, Tom Ogilvy "MarvInBoise" wrote: I have a document that has has validation/name ranges, e.g., in column A I have a dropdown choice of Apples/Oranges; in column B, if I have chosen Oranges in column A, I want the choices in column B to be Valencia/Blood, etc.; if I chose Apples in column A, then I want the column B choices to be Gala/Delicious, etc. It works currently with an =indirect(A1) as the formula in B1; however, I now want to expand to columns C, D, etc., so that if I have chosen Gala in B1, then I have choices in column C, and on and on. HELP! Thanks! Marv Lusk Boise Corporation |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data Validation based on data to left but several columns depe
Ah, is that Office2007? I don't see such a choice in my list under
Data/Validation? Only: any value whole number decimal list date time text length custom -- Marv Lusk "Tom Ogilvy" wrote: Debra Dalgleish's site: http://www.contextures.com/tiptech.html go down to the "D's" and under Data validation, find dependent dropdown. -- Regards, Tom Ogilvy "MarvInBoise" wrote: I have a document that has has validation/name ranges, e.g., in column A I have a dropdown choice of Apples/Oranges; in column B, if I have chosen Oranges in column A, I want the choices in column B to be Valencia/Blood, etc.; if I chose Apples in column A, then I want the column B choices to be Gala/Delicious, etc. It works currently with an =indirect(A1) as the formula in B1; however, I now want to expand to columns C, D, etc., so that if I have chosen Gala in B1, then I have choices in column C, and on and on. HELP! Thanks! Marv Lusk Boise Corporation |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data Validation based on data to left but several columns depe
Oh DUH, I got it! :(
Thanks! -- Marv Lusk Boise Corporation "MarvInBoise" wrote: Ah, is that Office2007? I don't see such a choice in my list under Data/Validation? Only: any value whole number decimal list date time text length custom -- Marv Lusk "Tom Ogilvy" wrote: Debra Dalgleish's site: http://www.contextures.com/tiptech.html go down to the "D's" and under Data validation, find dependent dropdown. -- Regards, Tom Ogilvy "MarvInBoise" wrote: I have a document that has has validation/name ranges, e.g., in column A I have a dropdown choice of Apples/Oranges; in column B, if I have chosen Oranges in column A, I want the choices in column B to be Valencia/Blood, etc.; if I chose Apples in column A, then I want the column B choices to be Gala/Delicious, etc. It works currently with an =indirect(A1) as the formula in B1; however, I now want to expand to columns C, D, etc., so that if I have chosen Gala in B1, then I have choices in column C, and on and on. HELP! Thanks! Marv Lusk Boise Corporation |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| imported data has weird columns on left | Excel Discussion (Misc queries) | |||
| Different validation list based on cellvalue on the left | Excel Worksheet Functions | |||
| create a data-series based on two different columns of data ? | Charts and Charting in Excel | |||
| DATA VALIDATION with LEFT function | Excel Discussion (Misc queries) | |||
| Hide Columns based on a Data Validation List | Excel Programming | |||
Hybrid Mode
