Hi folks,
Would someone be able to help me with a VBA I think I have to write in order me to create a call tracking tool.
What I want to do is to have a list of say 10 options in cell B and depending on what option is picked it will only give you a listing of the corresponding list in cell C (there are about 30 options in cell C) but if I select the option in B it will only give me 5 possibilities to choose from in C and not the 30 odd.

Hope the above makes sense.

Is this possible? Any and all help would be fantastic.