Pivot table, drop Day into Page fields and then use Show pages on that item.
Better yet though, assuming you will only be looking at one day at a time,
why not just Autofilter on the Day.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Joe E via OfficeKB.com" wrote in message
...
I have an excel spreadsheet that is too large to fit in one worksheet. I
was wondering if it possible to open the spreadsheet such that the
contents
are automatically divided into different worksheets so I can have all the
data I need open at one time. I would like to divide the data into
worksheets so that there is a separate worksheet for each unique value in
column A. For example if I had a spreadsheet that looked like this:
A B
Monday 6
Monday 1
Monday 2
Tuesday 1
Tuesday 3
Wednesday 4
Wednesday 5
Wednesday 4
I want it to automatically open in excel so that there is a Monday
worksheet, a Tuesday worksheet, and a Wednesday worksheet. Any ideas?
Thanks,
Joe
--
Message posted via http://www.officekb.com