One way to do it would be go ahead and filter the data on one worksheet,
then copy your filtered data to a new worksheet. Once you copy to a new
worksheet you should be able to view your data the way you want it.


--
petevang
------------------------------------------------------------------------
petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034
View this thread: http://www.excelforum.com/showthread...hreadid=469849