Dependent drop down lists based on dynamic data range

Hi Excel experts,

This is my first post and I am relatively new to Excel.

I have scoured the forums but haven't yet been able to find a solution to my particular problem.

I have data that resembles (I have also attached an example workbook as well if that is easier)

Column A.................Column B................Column C..................Column D.............Column E................Column F
Year.......................Quarter...................Month..................Product-Code...........[data A]................[data B]
2013.........................Q1.........................Jan........................SD-21...................13%......................0.05%
2013.........................Q2..........................Apr........................NV-12...................7%.......................6%

etc

I am hoping to have, on another sheet, a series of dependent drop boxes- Year, Quarter, Month, SKU- which after selecting then displays 'dataA' & 'dataB'.

So you could select- List 1: 2013 ----> List 2: Q1 ----> List 3: Jan ----> SD-21.................and then 13% and 0.05% are displayed.


The data will be continuously added to and so needs to be based on a dynamic data range.

I know that a pivot table is the perfect way to do this, however my bosses have requested that I do not use that format so it is easy for all staff to access.

So I think I need to construct some sort of dashboard sheet, I have experimented with OFFSET from other posts, but so far have had no joy.


Any help anyone could give would outstanding- am open to any solution....


Thanks in advance

Strud