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

V

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
 
M

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
 
D

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.
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Set Up 2
Pivot tables, IF statements, vlookups? 2
Pivot Table from two worksheets 1
Summary of Unique item values 2
calculate net income i.e. revenues (-) expenses in a pivot table 1
How to automatically update a 12 month budget 5
Excel 2007 pivot tables and conditional formatting 2
Problem filtering two fields to get an amount sum 1

Top