Excel - Auto populate monthly and quarterly data

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

omen666blue;1603322 Wrote:

One way to get the quarterly totals would be to use hidden helper
columns.  If that is an option, let me know and i'll mock a version up.


If the example workbook is the exact layout you have then it can easily
be done using hlookup.

S.


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
Spencer101

Thanks a lot Omen for the detialed explaintion. Works well and made my
life easy. Hats off to you


Hello Spencer, thank you very much for pointing me to the right
direction for the Quarterly data . If you could mock up a version for
me, that would be extremely great.example workbook is in exact layout
and unfortunately I am using Excel 2003 version.

Awaiting your solution to the quarterly problem.


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
Excel Dumbo

Excel Dumbo;1603342 Wrote:

A couple of questions:

1) Do you have the analysis toolpak addin installed on your machine?
Easy way to tell is format two cells (A1 & B1) in a new workbook at
DD/MM/YYYY dates).  In A1 type today's date and in B1 type
=EOMONTH(A1,0) and press enter.  If the date shown in B1 is the last day
of the month, then you have the toolpak installed and that makes life
easy.  If you get an error then you do not have it installed.

2) What happens when the date selected gets to November for example?
Should it just say Nov & Dec or should it be Nov, Dec and Jan of the
following year?


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
Spencer101

Hi
Your file is at this link: http://cjoint.com/?BGexpx8kguO
You will find some notes on the sheet
HTH
Cimjet

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

HTH
Cimjet