View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Here we go again....

Data Filter AutoFilter click the arrow on column A and select "April"

When finished reviewing, do Data Filter AutoFilter again and it toggles
everything back to normal......

Vaya con Dios,
Chuck, CABGx3



"ExcelBob" wrote:


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