I've created a master sheet for inputting data throughout the year and
want to do a drop down list so that only one month is shown at a time.

Firstly, how do I display a pick list in month order (April thru to
March) as opposed to alphabetical order?

Secondly, can it be set up so that it is not possible for the user to
show 'All' at once. Therefore only allowing them to pick one month at
a time..?

Thanks
ExcelBob


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