OOPS!

Forgot something!

If any cells are blank in the AlphaRoster sheet, they will appear as
"0" on the filtered sheets. You can clear that with
Format/Cells/Number/Custom and entering a "#" in the Type input box.
Apply that formatting for all the cells in the data range - you will
have to clear the "Filter" first.

Dean Thomas


--
Lost4Now
------------------------------------------------------------------------
Lost4Now's Profile: http://www.excelforum.com/member.php...o&userid=29345
View this thread: http://www.excelforum.com/showthread...hreadid=495964