Link Drop Down Box to Look up Values in another sheet

D

Deezel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can a drop down list be linked to values on another sheet? 1
Link a text box based on drop down box with four options MS Word 365 0
Drop Down List Dependant Formula 2
Link Drop Down with Pivot Table 2
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
Default Cell Values at Change 2
Formatted cell column in drop down list 1
Drop down list 0

Top