Hi,

i have created drop down in lets say A3(items are apple, orange, banana) AND
A4(From Japan, From China, From USA). If i select apple in A3 i want excel to
automatically pop me "From Japan" in A4. I hope i am clear.


Thanks,
RR