Hi Guys/Gals,

Quick question before I spin my wheels unnecessarily.

I have a dashboard worksheet amongst other worksheets such as raw data, calculation, and a list worksheet. What I have on my dashboard worksheet is a list box control form (non active x) that has single-selectable years. When I select 2010 or any year, my charts update fine because my list box control form has input ranges and cell links that are sourced from the cells calculation worksheet. Not a problem here.

I also have another list box control form (not active x) that has input range and cell link to show a long selectable list of people's names. Straight forward control. When I click a name, another section on my dashboard provides vital statistics about those people. However, this list box is not driven by Year. It is all people from 2009 - current.

What I want to do and not sure if possible without using VB (don't know much), is when a year is selected to only display the people's names based on the year that was selected.

Is it possible to use List Box Control Forms (without Active X) to dynamically display selectable data (people's names based on year criteria) in a new List Box Control Form (without active X), where I can then continue to use input ranges and cell link? I cannot see how as there is no way to put a formula in to say "IF =YEAR Then display all people's names".

Hope I explained well enough.

Thanks,

Tom

Thank you,

Tom