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