Pivot tables: Getting each item on a different page (worksheet)

[vsoler]

Hello everyone,

My problem is as follows: I have prepared a big database (a range with
a header line) that basically contains the budget expenses for each
department (cost center) of my company for a given year.

cost center code
expense description
authorized amount

I have summarized the expense in a pivot table per cost center.

I would like to give to each department its own expense and not
others'. I'd like to know is there is any means of getting, without
VBA, a worksheet per department, that can be e-mailed to them.

Should this not be possible, are there any others workarounds that I
can use to split the data in the pivot table?

I am using Excel 2000

Thank you

 

[Max]

Tinker along these lines, using the PT's PAGE area
Let's say the col header for the dept description? field is Dept
Place Dept into the PAGE area in your pivot
Then in the PT itself,
In the PAGE area, select the "(All)" for Dept
Click the PivotTable toolbar dropdown>Show Pages
In the dialog, Show All pages: Dept > OK
That'll explode all the depts listed in the page field into its own sheet,
and with the sheets named after each dept. Gives you exactly what you're
after.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik

 

[Debra Dalgleish]

After you create them, you'd have to copy those pivot tables, and paste
them as values. Otherwise each department would have access to all the
other departments' data.

 

[Max]

Good point. Admit I missed that in the elixir.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik

 

[Max]

You can group all the exploded sheets, then freeze it all at one go with an
entire sheet, in-place copy n paste special as values. Then ungroup ...
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---

 

[Shane Devenshire]

Hi,

Using the steps you have been given gets you most of the way there, next

1. Choose Window, Arrange Tile and resize the window so you can see a blank
area of the screen (gray).
2. Drag one of the sheets to this gray area and release.
3. Choose File, Send to...
4. Delete the single sheet file after sending it, unless you want to keep it
for something.
5. Repeat steps 2-4 for each departement.