I am struggling with this ...my worksheets are all in one workbook. There are
columns for: Name of Payor; Invoice #; Category of payment; Cheque #, Date of
Cheque; cheque amount

I need to get the "category of payment" and the Cheque Amount into a pivot
tablework that will tally them up and as I enter new info into those columns
the changes will be reflected in the table

How do I do that and what shoul it look like?