basically i want

all rows on a worksheet hidden (except rows 1 & 2)
default in a2 to be "april" (so it doesn't allow a blank)

if cell a2 = "april" show rows 3:41
if cell a2 = "may" show rows 42:80
if cell a2 = "june" show rows 81:11

etc

any magicians out there

--
ExcelBo
-----------------------------------------------------------------------
ExcelBob's Profile: http://www.excelforum.com/member.php...fo&userid=3415
View this thread: http://www.excelforum.com/showthread.php?threadid=54546