I have successfully made a pivot table to list categories & amounts from a bank account. I also have a cash account and I want to be able to list the amounts for the same categories from both accounts into one pivot table. Each account is on its own worksheet.



I have tried; (as an example)

'bank account'!$A$3:$E$100+'cash account'!$A$3:$E$100 - which doesn't work. I have also replaced the '+' sign with a colon ':'

Do any 'wise people' out there know if it is possible to get information from two worksheets into one pivot table using the same categories?

Any help much appreciated

Don