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