Cell A1 contains the heading MONTH:

Cells A3:A41 contain the word "April"
Cells A42:A80 contain the word "May"
Cells A81:A119 contain the word "June"

etc all the way to March.

I want to put a pick list in cell A2 with the months April thru to
March and when you select a month it only returns the rows containing
that month.
ie if you pick April from the list it only displays rows 3:41
if you pick May from the list it displays rows 42:80 etc etc

Can anyone tell me how I can do this?

Help greatly appreciated


--
ExcelBob
------------------------------------------------------------------------
ExcelBob's Profile: http://www.excelforum.com/member.php...o&userid=34152
View this thread: http://www.excelforum.com/showthread...hreadid=545455