Pivot from multiple sheets 05-28-10

hi,

i have the below data and i need to make pivot from multiple sheets.i have 
tried to make by selecting multiple consolidation ranges, bbut it is not 
giving me the flexibility that is available while doing in a single sheet...
Month	Processor	Process
Jan	Mark	Manual
Feb	Henry	Automatic
Jan	Chad	Automatic
Mar	Mark	Automatic
Apr	Mark	Manual
Jan	Chad	Automatic
Jan	Henry	Manual
Apr	Henry	Manual
Feb	Mark	Automatic
Mar	Chad	Manual
Jan	Mark	Automatic
it gives the belowformat...
Row	Process	Processor	Grand Total
Jan	15	15	30
Feb	6	6	12
Mar	6	6	12
Apr	6	6	12
Total	33	33	66

where as i need the below format...is it possible in making pivot from 
multiple sheets
Process	Month	Chad	Henry	Mark	Grand Total
Automatic	Jan	2		1	3
	Feb		1	1	2
	Mar			1	1
Manual	Jan		1	1	2
	Mar	1			1
	Apr		1	1	2
Total		3	3	5	11

0
Utf
5/28/2010 11:32:01 AM
excel.worksheet.functions 4936 articles. 2 followers. Follow

1 Replies
747 Views

Similar Articles

[PageSpeed] 34

Excel 2007 PivotTable
Consolidate multiple tabs.
Reverse PT to get flexible PT.
With macro.
http://c0718892.cdn.cloudfiles.rackspacecloud.com/05_28_10.xlsm

0
Herbert
5/29/2010 4:20:42 AM
Reply:

Similar Artilces:

Identical Name on multiple workbook pages
As a hardened Excel/VBA nut, I'm probably going to be really embarrased when I get the answer to this, but here goes... I have a workbook containing a worksheet that records weekly data. I have a named range ("Data") which I select then clear, via GoTo. Each week, I copy the latest week's worksheet and create a new worksheet for the new week. And each week, I select the range "Data" and clear it in the most recently created worksheet. the thing is, I always thought that Range names were unique across a workbook, and that you couldn't have the same Range N...

Pivot table, calculating % difference of subtotal rows
This is what I need to do: I have rows of data in a pivot table that have subtotals associated with them (automatically generated via the pivot table). I need to to take the subtotals for 2009 and 2010 and calculate the % difference. Here's a screenshot of what I'm talking about: http://home.comcast.net/~wilsoch/PercentDiff.jpg Is this even possible or am I going to have to do this manually? Hi I have'nt seen the screenshot as am at work , go to Pivot Table>Formulas>Calculated Field wilsoch@comcast.net wrote: >This is what I need to do: I have rows of ...

New workbook/sheet defaults
I'm using Excel 2003 and have put two files Book.xlt and Sheet.xlt in the startup folder whose path is specified in: Tools|Options|General|At startup open all files in: Sheet.xlt works fine for adding new sheets and Book.xlt works fine for new workbooks created by clicking the New icon on the Standard toolbar, but not if I create it using File|New then select Blank Workbook from the New Workbook task pane or if I click Templates|On My Computer then select Workbook. How do I have these actions use the Book.xlt and Sheet.xlt files that I've created for the purpose? JF. I would p...

PIVOT tables and publishing thrm on a webpage
Is there a way to publish a pivot table in a html page but still kee exactly the same funcitonality that you have on a Excel spread sheet either by converting it to a java applet or something else . Any hel would be much appreciate -- Message posted from http://www.ExcelForum.com ...

Is it possible to export Excel sheet data to..
Subject: Is it possible to export Excel sheet data to.. Is it possible to dump Excel sheet data to Access DB in real time (or once a minute or so, or per calculation event or other event)? if so - how? Thanks. Avinoam, You may be able to use a linked table in Access. File - Get external data - Link tables. The data is kept in the Excel sheet, but can be used in Access as with any other table. -- Earl Kiosterud www.smokeylake.com "avinoam.aharoni" <avinoam.aharoni@SupportX.com> wrote in message news:966893D33443@123456789.spx.com... > Subject: Is it possible to ex...

Insert Rows in Balance Sheet Template
Using Excel 2002 I cannot find a way to insert/add additional rows to the existing 12 rows allotted in the Balance Sheet template. I learned from another question that I can Ctrl+D to copy the formulas down to blank cells to keep the balance going, but no way to add more rows, since the template is so short. Rows is greyed out on the Insert menu, and Nothing comes up on a right click. Can you please help me. Thanks. Try unprotecting the sheet and they should work. -- goober ------------------------------------------------------------------------ goober's Profile: http://www.exce...

Pivot Table question #4
Hi I have spreadsheets that take data via a pivot table from an OLAP cube that is held on a terminal server. The spreadsheets hold figures entered by me and figures obtain from the pivot table. I want to enable the automatic update on the pivot table but the pivot table is sorted by a project number obtained from the OLAP cube. My problem is if a new project is added to the OLAP cube then it is automatically selected from the drop down list. I want to be able to turn this off so that it only selects the project I have previously chosed. For example if I have selected the filter nu...

add a header and or footer to all sheets/tabs
I have a large workbook that I need to add a header and footer to each sheet/tab. I do not want to have to go to each sheet and do this, there are grapghics and propreitary notes, etc. it would be a lot of work to have to go to each sheet. Can I add the header and footeronce and have it apply to all sheets/tabs in the workbook? Please advise ASAP. Thanks for any help you can provide. Group the sheets first. Right-click any sheet tab, and hit Select all sheets. Don't forget to ungroup when you're done!! ************ Anne Troy www.OfficeArticles.com "Sharon" <Sh...

how do Ii remove the grey page numbers in a work sheet
how do Ii remove the grey page numbers in a work sheet Try going to the View menu and unchecking Page Break Preview On Wed, 2 Feb 2005 11:01:08 -0800, "parker1230" <parker1230@discussions.microsoft.com> wrote: >how do Ii remove the grey page numbers in a work sheet You may be in page break preview mode. Go to "View" and select "normal" Regards Bill K "parker1230" <parker1230@discussions.microsoft.com> wrote in message news:5A65FC73-CAA0-428D-8ECD-0C2A2E15B799@microsoft.com... > how do Ii remove the grey page numbers in a work she...

Allen Browne Client Search Multiple Like Statements
Hi all, I need to have this code search multiple fields, but I keep getting "Expected end of statement" on the Me in the second to last line: If Not IsNull(Me.txtFilterMainName) Then 'strWhere = strWhere & "([MainName] Like ""*" & Me.txtFilterMainName & "*"") AND " strWhere = strWhere & "([Address1] Like ""*" & Me.txtFilterMainName & "*"") OR " & _ strWhere = strWhere & " ([StreetName] Like "" * " & Me.txtFilterM...

opened Excel w/sheet from email attachment, updated, saved & cant
I emailed an Excel worksheet from my office to my home - opened it from my Outlook Express folder - updated file extensively - saved several times during the four hours I worked - closed & now can't find the updated file. I forgot I had opened it from the email and never saved it to my C drive. However, I saved it several times while I was working on it. Shouldn't the file in my email be the updated saved file? It's not and I can't find it anywhere. I believe this happened once before to me. Any suggestion would be appreciated. I've lost a lot of work if the file...

Support of multiple users in Outlook?
Hi, Palm convert here with a question. In my Palm desktop I was able to separate my Notes, Calendar, Tasks, etc. from my wife as a separate user. We both had palm devices and each maintained separate schedules on our devices and on the desktop. How do we do that in Outlook? Thanks, John "John" <ljohnwu@yahoo.com> wrote in message news:u2bnY$0DGHA.3528@TK2MSFTNGP12.phx.gbl... > Hi, > > Palm convert here with a question. > > In my Palm desktop I was able to separate my Notes, Calendar, Tasks, etc. > from my wife as a separate user. We both had palm ...

Multiple POP accounts in Outlook 2003
Hello, I have multiple POP accounts on my Outlook 2003 client. How do i setup Outlook to save mail from the multiple POP accounts to different folders so that it makes it easier for me to sort out my mail? TIA! //j you'll need to use rules... or use search folders configured for each account. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines (Visual QuickStart Guide) Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: ...

Do Pivot Tables have an automatic data range expansion?
As I add new rows of data to my data base, my pivot table will not expand to include them after refreshing. Is there any way of setting the pivot table to include the entire database regardless of its continuously growing size? Right now, as I add a new row of data I must delete my old Pivot table and create a new one from scratch. Is this normal? You can use a dynamic range that grows/contracts with your data. Debra Dalgleish explains it all at: http://www.contextures.com/xlNames01.html#Dynamic David.c.h wrote: > > As I add new rows of data to my data base, my pivot table wil...

Calculate from another sheet
If i in a sheet have a1=1 , b1 =2 , c1 = 3 , d1 = 4, e1 = 5 and so on and in a2 = 100, B2 = 100, c2 = 100 , e2 =100 ans o on Then in another sheet i write maybe 4 then i want a cell there have a sum from 1 to 4 In this case from a2 to e2 if I write maybe 2 The a sum from a2 to b2 Can i do this? If 4 is A2 to E2, and 2 is A2 to B2, presumably 3 is A2 to about half way between C2 and D2? It sounds as if you want the OFFSET function; details in Excel help. -- David Biddulph "alvin Kuiper" <alvinKuiper@discussions.microsoft.com> wrote in message new...

How to add multiple message senders to the blocked list automatica
-- Steve ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=5597e420-8dc2-4fc5-88df-130a7cc9fe32&dg=microsoft.public.outlook ...

How do I create a spread sheet for tracking batting statistics?
Trying to keep a running log of batting stats for the season. Can anyone help? http://www.baseball-almanac.com/bstatmen.shtml "Robert" wrote: > Trying to keep a running log of batting stats for the season. Can anyone help? ...

Transfer combined investment transactions to multiple new accounts
In Money 2005 Deluxe, I have an investment account (with related cash account) with about two years of transactions. This mutual fund account (TRP) uses a separate account number for each mutual fund holding so that when I upgraded to Money 2005 and set up on line services for this account it downloaded each mutual fund investment as a new account. I can't merge all of these duplicate accounts in Money as it only allows you to merge one time so I then transfered (using copy) all my investment transaction from the combined existing account to each of the new individual investment ac...

COUNTIF
I need to calculate how many same products are chosen in a table from validated data to show a tally (using 2 sheets, 1 v/data & Tally List [Sales Sheet] and 1 v/lookup [Data Sheet]). I've tried SUMIF and COUNTIF but didn't seem to work at all on the v/data sheet unless I stuffed up, but where? How do i calculate how many "Blue" items are listed each time a Blue item is added to the Sales Sheet via combo/lists? Each time a new item is listed, it will automatically appear in the tally list as a new item and/or count tally of appearences sorted by ranking. There are ...

Splitting multiple cell contents from 1st column into 4 columns
n my first column I have 4 cells (1-4) (5-8) etc. with general content. The content from each of these 4 cells needs to be placed in a separate column to make a list that I can sort etc. Example: COLUMN A 1 01-04-425-001 2 Heatherridge Road #301 3 Harry Smith 4 H25 Condo Fairfax Place 5 01-05-356-041 6 McGrath Street # 56 7 Mary Jones 8 B45 Condo Lemon Circle . . . . . . and so on and so on every 4 cells. I have hundreds of 4 cell descriptions. I just can't do this one by one. Can anyone help, PLEASE, PLEASE. I am really a novice at Excel though I use it for e...

Receiving duplicate emails 01-20-10
In Windows Live Mail I'm receiving the same emails over and over again. This only happens to my pop3 accounts in Windows Live. I've looked at the properties on both pop3 accounts and the "Leave message on server" box is unchecked. This problem just started within the past 36 hours. I delete the same ones when they come in each time but as the day goes on I'm receiving dozens and dozens of repeating emails as well new ones which then become repeaters. I've checked the emails on my server and they are not doubled or tripled, etc. HELP! Anyone have a solut...

Merging to-do/task lists from multiple inbox folders
Hi- I am using Outlook 2007 and am trying to figure out how to merge to-do/task lists from multiple inbox folders. I have my inbox associated with my name, and then also a folder with my name that is associated with another inbox that is used by several people on one project. (When emails come into the latter folder, I sort the ones that I can deal with into the subfolder with my name.) For my personal inbox, I can flag emails and they will pop up in my to-do box, but when I flag things in my sub-folder they don't show up in my to-do box, and I can't figure out where t...

"A Formula or sheet..."
Windows Vista Ultimate - SP1 RC1 Office 2007 Professional When I try to copy a worksheet I get the following: "A formula or sheet you want to move or copy contains the name '_XXXX', which already exists on the destination worksheet. Do you want to use this version of the name?" This messages appears many time before the sheet is finally copied. I have been clicking the yes button and the task is completed. Is there a work-around, or add in, that allows me to go in and delete all these names so I can just copy the sheet w/o all the extra effort. It seems to me I ran i...

Fixed Assets GP 10 Security
I have added the Fixed Asset module to GP 10. I have added the FA_DEFAULT Role to users who will be using FA. When I go to Cards the Fixed Asset menu option does not appear. The only people who do see it are the Power Users. What step am I missing? Rich, FADEFULT_USER task will only provide access to set of FA lookups and few other options. You have to set security task for Users seperately for each window and other accesses by going to Security Tasks, Roles and then to Users -- Thanks Janakiram M.P. MCP-GP http://janakirammp.blogspot.com "Rich Wheeler" wrote: > I hav...

Comments & protected sheets
I'm guessing I already know the answer to this, but is it possible to leave comments on a protected sheet? Yeah??????? Did you mean add/edit/delete comments on a protected sheet? If yes, then there's an option to protect (or leave unprotected) objects when you do Tools|protection|protect sheet that you can choose. PaulM wrote: > > I'm guessing I already know the answer to this, but is it possible to leave > comments on a protected sheet? -- Dave Peterson ...