Drop down list

[Guest]

Hello,

My last message was not understood.

I have the following table on Sheet1

Sheet1
A(fruit) B(packing) C(qty) D(label)
apples box z 25 units labeled PF
apples box z 50 units labeled PF
apples box w 50 units labeled TR
lemmons box y 100 units labeled LM
lemmons box y 100 units labeled LM
grapes box x 200 units labeled GR
grapes box x 250 units labeled GR
grapes box x 300 units labeled GR

On a blank Sheet2, I want to be able to have this:
A(fruit) B(packing) C(qty) D(label)

So if I select a cell under the colum fruit, a drop down list should appear
showing the information of fruit from Sheet 1, then If I select apples, on
the next column (packing) should only appear on a drop down list the
information related to that specific item which would be box z or box w, if
selected box w, then on column qty only should appear qty 50 units from a
drop down list.

Anyone undertand this and can help please?

 

[Roger Govier]

Hi

Take a look at Debra Dalgleish's site
http://www.contextures.com/xlDataVal13.html

 

[Guest]

Hi,

Thank you very much.

JP

Hi

Take a look at Debra Dalgleish's site
http://www.contextures.com/xlDataVal13.html