Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CREATE DATA FORM FOR DEPENDANT DROPDOWN LIST IN EXCEL
I need to enter data in rows under around 5 column headings
Column A has a dropdown list covering around 6 items .- Each of these 6 items have 2 to 3 dependent items coming under and then these dependent items under column B have around 3 to 4 dependent items under column C - etc etc Can someone help me to create a dataform that would only allow to pick data that is dependent upon previous left column .and thus enter the data in an empty row. Subsequently I have a pivot which picks up all this entered data -i dont need help on that - but only on the data entry form Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CREATE DATA FORM FOR DEPENDANT DROPDOWN LIST IN EXCEL
See Debra Dalgleish's instructions on working with Dependent Lists:
http://www.contextures.com/xlDataVal02.html Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Rohin Bhatia" wrote: I need to enter data in rows under around 5 column headings Column A has a dropdown list covering around 6 items .- Each of these 6 items have 2 to 3 dependent items coming under and then these dependent items under column B have around 3 to 4 dependent items under column C - etc etc Can someone help me to create a dataform that would only allow to pick data that is dependent upon previous left column .and thus enter the data in an empty row. Subsequently I have a pivot which picks up all this entered data -i dont need help on that - but only on the data entry form Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CREATE DATA FORM FOR DEPENDANT DROPDOWN LIST IN EXCEL
Dear Ron
thanks for a quick reply - I did try this before but seems to work only for two colums Plus - how to create the data form ? Regds Rohin "Ron Coderre" wrote: See Debra Dalgleish's instructions on working with Dependent Lists: http://www.contextures.com/xlDataVal02.html Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Rohin Bhatia" wrote: I need to enter data in rows under around 5 column headings Column A has a dropdown list covering around 6 items .- Each of these 6 items have 2 to 3 dependent items coming under and then these dependent items under column B have around 3 to 4 dependent items under column C - etc etc Can someone help me to create a dataform that would only allow to pick data that is dependent upon previous left column .and thus enter the data in an empty row. Subsequently I have a pivot which picks up all this entered data -i dont need help on that - but only on the data entry form Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CREATE DATA FORM FOR DEPENDANT DROPDOWN LIST IN EXCEL
The Contextures website only used 2 dependent lists to exhibit the concept.
You can use that technique for as many columns as you need. Perhaps if you posted more details about your situation we could offer more help. *********** Regards, Ron XL2002, WinXP "Rohin Bhatia" wrote: Dear Ron thanks for a quick reply - I did try this before but seems to work only for two colums Plus - how to create the data form ? Regds Rohin "Ron Coderre" wrote: See Debra Dalgleish's instructions on working with Dependent Lists: http://www.contextures.com/xlDataVal02.html Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Rohin Bhatia" wrote: I need to enter data in rows under around 5 column headings Column A has a dropdown list covering around 6 items .- Each of these 6 items have 2 to 3 dependent items coming under and then these dependent items under column B have around 3 to 4 dependent items under column C - etc etc Can someone help me to create a dataform that would only allow to pick data that is dependent upon previous left column .and thus enter the data in an empty row. Subsequently I have a pivot which picks up all this entered data -i dont need help on that - but only on the data entry form Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CREATE DATA FORM FOR DEPENDANT DROPDOWN LIST IN EXCEL
Dear Ron
ok - i will relook at this website thanks Rohin "Ron Coderre" wrote: The Contextures website only used 2 dependent lists to exhibit the concept. You can use that technique for as many columns as you need. Perhaps if you posted more details about your situation we could offer more help. *********** Regards, Ron XL2002, WinXP "Rohin Bhatia" wrote: Dear Ron thanks for a quick reply - I did try this before but seems to work only for two colums Plus - how to create the data form ? Regds Rohin "Ron Coderre" wrote: See Debra Dalgleish's instructions on working with Dependent Lists: http://www.contextures.com/xlDataVal02.html Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Rohin Bhatia" wrote: I need to enter data in rows under around 5 column headings Column A has a dropdown list covering around 6 items .- Each of these 6 items have 2 to 3 dependent items coming under and then these dependent items under column B have around 3 to 4 dependent items under column C - etc etc Can someone help me to create a dataform that would only allow to pick data that is dependent upon previous left column .and thus enter the data in an empty row. Subsequently I have a pivot which picks up all this entered data -i dont need help on that - but only on the data entry form Thanks |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CREATE DATA FORM FOR DEPENDANT DROPDOWN LIST IN EXCEL
Hi Ron
I have re checked and reduced the data to 4 columns only - works ok till 3rd column - but in the 4th column it picks up dependancy only linked to 3rd column.thus data in 4th column is all wrong. The data in the 4th column has to link with dependancy on the 3rd column as well as the 2nd column- ( like it works ok when u use filters say for all columns ).How do I solve this - I have used the OFFSET / match formula etc . thanks Rohin "Ron Coderre" wrote: The Contextures website only used 2 dependent lists to exhibit the concept. You can use that technique for as many columns as you need. Perhaps if you posted more details about your situation we could offer more help. *********** Regards, Ron XL2002, WinXP "Rohin Bhatia" wrote: Dear Ron thanks for a quick reply - I did try this before but seems to work only for two colums Plus - how to create the data form ? Regds Rohin "Ron Coderre" wrote: See Debra Dalgleish's instructions on working with Dependent Lists: http://www.contextures.com/xlDataVal02.html Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Rohin Bhatia" wrote: I need to enter data in rows under around 5 column headings Column A has a dropdown list covering around 6 items .- Each of these 6 items have 2 to 3 dependent items coming under and then these dependent items under column B have around 3 to 4 dependent items under column C - etc etc Can someone help me to create a dataform that would only allow to pick data that is dependent upon previous left column .and thus enter the data in an empty row. Subsequently I have a pivot which picks up all this entered data -i dont need help on that - but only on the data entry form Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select dropdown list dependant on value of a given cell | Excel Discussion (Misc queries) | |||
create a list dependant on info in a column | Excel Worksheet Functions | |||
Excel 2003 - Customise a Data Form for dropdown lists | Excel Discussion (Misc queries) | |||
How do I create a dropdown list using data from a different workbo | Excel Worksheet Functions | |||
Use dropdown list from Form | Excel Discussion (Misc queries) |