Hi
If you make the date a Page field, then from the PT toolbar choose Show
pages, a sheet will be created for items in the page area, with all of
the lines relating to that value.

Be aware however, that you cannot Group dates within a Page area.
If you do want to group dates by month / year. then drag the Date filed
first to the Row area, do the grouping, then drag year and Month to the
Page area

--
Regards

Roger Govier


wrote in message
oups.com...

Date Stock Ticker Security # Shares/Par Price Value
12/31/2007 Google GOOG 12345678 10 $458.00 $4,580
12/31/2006 Microsoft MSFT 12456789 8 $31.30 $250

Dates in column A and is sorted. Autofilter works well to view the
data, but I am needing it in new sheet for each date. (Not my idea).
Is there a function in pivot table to create a new sheet for each
unique value? I seem to remember something like that, but I am not
sure how it works.

On May 15, 12:25 pm, "Don Guillett" wrote:
Properly formatted dates in what column?
Isdatasorted?
copy/paste sample layout.
etc.
Why not just usedatafilterautofilter or a pivot table?

--
Don Guillett
SalesAid Software
...@gm ail.com wrote in
message

oups.com...

Hey guys, any help is appreciated. Here is my situation: I have a
spreadsheet with over 4000 rows ofdata. Thedatahas the month end
date in column A, but there is an arbitrary number of rows for each
month end. Is there a way tomovethe rows ofdatathat all have the
same month end date to anewsheetnamed for the corresponding date.
As there are over 10 years of month enddata, this is quite arduous
without a macro.