โJan-08-2014 09:22 AM
โJan-09-2014 11:18 AM
ChiefUSN wrote:
I believe that your answer may be found here. He explains it better than I could.
http://www.youtube.com/watch?v=5yj1a2VWpQ4
โJan-09-2014 06:45 AM
โJan-09-2014 05:33 AM
โJan-09-2014 01:03 AM
hbillsmith wrote:Never heard of that - I didn't add any third party software.
Sounds like you were using the third party add in ASAP utilities.
โJan-08-2014 05:04 PM
โJan-08-2014 02:03 PM
hbillsmith wrote:
I'll try to answer. I spend most of my days doing nothing but pivot tables. I'm not sure I understand your example though. Assume that with the workbook open, you working in the worksheet/tab that has the master data file. Select the menu option to 'Insert Pivot Table' (that's where it is in the current version of Excel). In older versions, it was under the menu option for Data. Once you find the Insert Pivot Table, you'll see the familiar dialog that let's you put your table to appear in the same worksheet (you don't want that) or to have it be on a new worksheet. Choose new worksheet and it will put the initial pivot on a new tab. Keep going back to the master data and re-running Insert Pivot until you have created as many Pivot tabs as you like. Then one-by-one, go to a Pivot tab, right-click on the tab name and give it whatever name you want. While on the tab, manipulate the pivot fields to get the view you are looking for.
Hopes this helps.
โJan-08-2014 01:16 PM
โJan-08-2014 09:53 AM