Hi expert users,

In Excel 2007
Currently I have a dashboard with a dropdown list, selection available "Q1", "Q2", "Q3", "Q4".

Data
ABC Apr 12 Q1
DEF Jul 12 Q2

Current Dropdown list
Q1 shows Q1
Q2 shows Q2

My aim is:

Select "Q1", only Q1 data is shown
Select "Q2", Q1 + Q2 data is shown

How can I tweak it?

Advanced thank you to any advices.