#1
|
|||
|
|||
Excel pivot table
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 |
#3
|
|||
|
|||
Hi Jeff,
It certainly looks like it could be the answer. It's late here so I would be in trouble if I start tonight! It will be something to struggle through tomorrow. I will let you know how I get on. Thanks, Don |
#4
|
|||
|
|||
Consolidated Pivot Tables
Hi Jeff,
Thank you for your advice. I was able to consolidate data from two worksheets into one pivot table following your help and direction although I have been unable to manipulate the columns into the format I want for printing but that is something I will work on. The other frustrating thing, although I am sure there is a very simple answer I have failed to find, is that every time I 'Refresh' to load new data into the pivot table the columns automatically adjust reducing the width to accommodate the largest set of data. I want it left at the widths I set ready for printing. Any clues!? Thank is again for your help. Regards, Don |
#5
|
|||
|
|||
Hi Don,
There is a setting in the pivot table options that should work... http://excelunplugged.com/2014/05/14...table-refresh/ |
#6
|
|||
|
|||
You are a star
Thank you again Jeff. You are a star. I knew it would be simple but I just had to find it and the Excel Help didn't! I must have been asking the question in the wrong way!
Don |
#7
|
|||
|
|||
Hi Don,
You're welcome Glad you have what you need so far and best wishes for the rest of your project. |
Tags |
pivot table;tables |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pivot Table and Excel 2016 vs 2007 | torrione73 | Excel | 3 | 07-28-2016 07:24 AM |
Excel 2010 Pivot table problem | Kris TenEyck | Excel | 4 | 02-01-2014 01:26 AM |
Grouping Dates in Excel Pivot Table | mskennedy | Excel | 2 | 02-27-2013 11:09 AM |
Excel Pivot Table Calculated Field | BertLady | Excel | 0 | 05-21-2012 10:51 AM |
Excel 2010 Pivot Table Qs | SchneeBaer | Excel | 2 | 10-03-2011 08:45 PM |