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

As far as tutorials go, this seems as good as any:
http://www.youtube.com/watch?v=vgv8_4sQ4WM

As an alternative, you may want to consider using a Pivot Table:
http://www.youtube.com/watch?v=CuhQ9lSMmjg
http://www.youtube.com/watch?v=bEUmszKXGCk
http://www.youtube.com/watch?v=-zj7BGCGAQk&

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 youre probably going to have a
migraine before you finish.


Good luck,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"kblostyankee" wrote:

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