Showing all info under subtotals with large listings

K

kblostyankee

I am trying to generate a report with thousands of employee payroll
deductions. many have multiple invoices and need a subtotal as well as other
info included, however, I cannot figure out how to display all info on the
subtotal line. If I had that, I could filter out the individual invoices. I
need them all sorted by facility, name, and date and formated into numbers, 2
decimals. I have tried working with pivot tables, but I am not too familiar
and I also need to have formulas in subsequents columns.
Also is there an easy way to immediately delete of all of those with a zero
balance after filtering?
Can anyone help?
Thanks so much,
Kathleen
 
R

ryguy7272

As far as tutorials go, this seems as good as any:

As an alternative, you may want to consider using a Pivot Table:

If you use Excel 2007, look on YouTube for a 2007 tutorial; 2007 is quite
different from 2003...takes a bit getting used to.

Finally, if you are doing this for thousands of employees, it is definitely
time to start learning Access. There is a learning curve, coming from Excel
world, but Access will do some things extremely easy, such as what you are
describing here. Excel will do this too, but you’re probably going to have a
migraine before you finish.


Good luck,
Ryan---
 

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

Top