Duplicating parts of a worksheet

  • Thread starter Thread starter msherman83
  • Start date Start date
M

msherman83

I am working with an excel worksheet with five columns (account, date
description, purchase order, and expense amount). I want to summariz
from this worksheet all of the expenses by account.

I know how to get the total expenses for each account from this list
but I want to be able to create another worksheet for each account tha
lists date, description, purchase order, and expense amount. Is ther
a way to do this without requiring double entering of everything
 
This sounds like a job for a Pivottable.

You can create a nice summary report based on your master worksheet.

Then you can drill down into any of those pivottable total fields and show the
rows of data that were used to make this total.

If you want to learn more about pivottables, here are a few links.

Debra Dalgleish's pictures at Jon Peltier's site:
http://www.geocities.com/jonpeltier/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx

====
I think I'd do the pivottable stuff--it's very quick after you spend a little
time learning. But I wouldn't separate my data.

But I would apply Data|filter|Autofilter to the range so I could filter by just
the stuff I wanted to see.

And if you use =subtotal(), you'll see that it only applies to the visible
cells. (It ignores the rows hidden by the autofilter.)
 
Back
Top