Drop down list
 

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?

Drop down list
 

Hi

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

--
Regards

Roger Govier


"juanpablo" wrote in message
...
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?

Drop down list
 

Hi,

Thank you very much.

JP

"Roger Govier" wrote:

Hi

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

--
Regards

Roger Govier


"juanpablo" wrote in message
...
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?