I'm not sure the exact structure of your spreadsheet, however you could
try using VIEW\CUSTOM VIEWS

Select your main data page
Create a view titled "All Info" or similar
Now make the main sheet look like your summary sheet by
1 set up an Auto Filter to hide the rows that you don't want to see
2 hide the columns that you don't want to see
Create a new view titled "summary"

You can now toggle between the 2

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=555148