Call tracking VBA

**Spurs** · 02-16-2009, 12:47 PM

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.

**Leith Ross** · 02-16-2009, 04:27 PM

Hello Spurs,

Welcome to the Forum!

Are these options in the cells shown using a Data Validation List or are the options all in a single cell separated by commas or some other character? How do you determine which 5 to use? Also, please let us know which version of Excel you are using.

**Spurs** · 02-18-2009, 12:52 PM

Hi Leith,
I will be using the data validation list to make the selections. What I have done is placed all my main criteria in column A and depending on what the person selects they will be given the options in column B to match. To be honest I don't want to capture a tonne of information just the basics to begin with. I'm currently using excel 2007.

If you think using a different option would be easier please go ahead and suggest, this is something new to me and just beginning to learn so all the help and knowledge you can pass on I would be more than grateful.

Cheers

**Leith Ross** · 02-18-2009, 01:19 PM

Hello Spurs,

I would help to see what you have so far. Can you post a sample workbook? I don't have 2007. If you could post it in 2003 format, it would be appreciated. Data validation should work the same in 2003 as 2007.

**Spurs** · 02-19-2009, 06:09 AM

Hi Leith,
I have attached a breakdown of what I have, in the first tab listings I have just put in what the two drop down menus would have in column A say you would select Card Expired the will give you 3 further options to choose from (see second tab) these would be reissue, admin fee, chase reissue. I feel I have captured all the main detail but if I need to update I can do this at a later date.

Thanks again for you help