J
Janna
I am using Xls 2003
i want to make a list of item - let call it list A
then i want to select one of the items in list A and another list (say list
B) must give me the details of the item selected in list A.
let use an example
List A = 1) car 2) boat 3) bicycle
when i select 1) car - List B show me 1) 4 doors 2) 4 wheels 3) stearing wheel
when i select 2) boat - List B show me 1) sail 2) rudder 3) sailers
when i select 3) bicycle - List B show me 1) 2 wheels 2) peddals 3) saddle
can i do this in excel?
i want to make a list of item - let call it list A
then i want to select one of the items in list A and another list (say list
B) must give me the details of the item selected in list A.
let use an example
List A = 1) car 2) boat 3) bicycle
when i select 1) car - List B show me 1) 4 doors 2) 4 wheels 3) stearing wheel
when i select 2) boat - List B show me 1) sail 2) rudder 3) sailers
when i select 3) bicycle - List B show me 1) 2 wheels 2) peddals 3) saddle
can i do this in excel?