I want the default month to be April and all other months to be hidden
until selected from the list. I don't want the user to be able to
'show all' and I want the list to be in Month order as opposed to
alphabetcal order.

That's why Autofilter is not good enough.

I know it's more straightforward just to use Autofilter and be happy
with it but I would prefer it this way if anyone can work out how it
can be done!


Cheers Everyone


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