I am, as you will see from the attached, a very basic user of Excel. I have tried innumerable times to work through help pages to try and get a pivot table to combine the information from two worksheets into one list by category. The attached are the accounts from a shooting (hunting) club - one bank, the other cash. How do I get this information to provide two lists by category/date, one for income, the other for expenditures, on a further two worksheets (in a similar format to that shown)?
The attached shows how I would like the information presented. At the moment I fill in the category lists manually. My frustration is not having to do this manually, as over a year it is 'something & nothing', it is the fact that I assume Excel can do it for me but I just can't figure out how!
Any help gratefully received.
Don
Bookmarks