Link Drop Down Box to Look up Values in another sheet
 

Hello:

I am working on the balanced scorecard for our company. I have a BSC on one
of the Main worksheets followed by the supporting sheets for around 40+ KPIs
/ Metrics.

On the Main sheet I am able to set up a drop down list for Year and Month:

Year
2007
2008
2009
2010.....

Month
1
2
3
4.....

On the supporting sheet the data is also stored in columns for each Month
and Year eg.

ROE DATA:
2008 |CellA8|
1 |Cell A9|
ROE % |Cell A11|

I want the user to select the Year and the month on the main Sheet and get
the desired info updated on the mainsheet instantly. Please let me know a way
of doing it. I will follow the same for all the other metrics

Thanks Much!
Deezel