Hi Again
This one I installed Data Validation list so you don't need to type, just
select.
Your choice.
http://cjoint.com/?BGex1w7ypfW

HTH
Cimjet
"Excel Dumbo" wrote in message
...

Hello Dear friends,

Please help me to auto populate monthly and quarterly data data from a
table of monthly figures. Please see attached.

Basically just by by updating the current month in B2 cell, data should
auto matically populate from the table shown
Say if I type July in B2 cell, it should automatically populate the
values from the table on the right for the month of July

Similarly for the Quarter.


Appreciate your attention


+-------------------------------------------------------------------+
|Filename: Auto Populate by current month.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=448|
+-------------------------------------------------------------------+



--
Excel Dumbo