$$Excel-Macros$$ Pivot Table and Slicer in Excel

Hi Friends, Feels like worth sharing the video about Pivot Table and Slicer in Excel. *https://youtu.be/jGUEkgtmATw * ​ Thanks & Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official

$$Excel-Macros$$ Pivot Table Question

I have data in two columns as shown below. I would like to get the second highest value, for each label, by using a pivot table. For example, for Adam, i should get 10, for Banana I should get 20 and so forth. I have tried the LARGE function, as a calculated field, but am not succeeding. I

$$Excel-Macros$$ Pivot Table - Copy Row

Please help me on this For the PT attached every time I filter by Cell Zone , there are two rows of interest Total Count & Total Amount when I filter say for Zone A I want to copy the two rows to new sheet . then I filter for zone B , I want to copy the new resulting rows to the new sheet

$$Excel-Macros$$ Pivot Table & Counting Colors w/conditional formatting

Anyone, I have a macro for counting colors that works on a normal worksheet. Problem: Clever created Pivot table with colors(Green, Red, Black..etc) that have numbers and text when you hover over the color Example: When cursor is over the Green value = 5(RED = 3) with text for the

Fwd: $$Excel-Macros$$ PIVOT TABLE CHART TAKE SCREEN SHOT

Hello Team, I have an requirement where the data from Pivot table chart as to be copied into the Power point slide(or in the excel itself as bitmap image) . In the same pivot table i have multiple filter(values) to select. since I have to take 12(conditions) print screen from same pivot table

$$Excel-Macros$$ PIVOT TABLE CHART TAKE SCREEN SHOT

Hello Team, I have an requirement where the data from Pivot table chart as to be copied into the Power point slide(or in the excel itself as bitmap image) . In the same pivot table i have multiple filter(values) to select. since I have to take 12(conditions) print screen from same pivot table

Re: $$Excel-Macros$$ Pivot Table from multiple sheets

Dear André Luiz D´Avila, Thanks for giving your valuable time for giving reply on my post. But what you replied is very simple and known to be but not useful as because: - 1. The examplese (i.e. columns) in both purchase sale sheet will be more than 50 per sheets. and that too different from

Re: $$Excel-Macros$$ Pivot Table from multiple sheets

Hello, You have a excel sheet with table purchase and other one with Sales. In order to combine both of them, the fast way is to create a 3 sheet. In that third one, create another table. Paste de purchase table and below paste the Sales table. After that create a Pivot using this new table. I

Re: $$Excel-Macros$$ Pivot Table from multiple sheets

Refer below link https://support.office.com/en-au/article/Consolidate-multiple-worksheets-into-one-PivotTable-report-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5 On 13-Mar-2015 7:12 pm, B Sharma sharma@gmail.com wrote: Dear All Excel Experts, From a very long time, I am trying to create a pivot

$$Excel-Macros$$ Pivot Table from multiple sheets

Dear All Excel Experts, From a very long time, I am trying to create a pivot table using two or more tables, but not getting appropriate results. Please help me , if anybody has ever done so. For e.g. in one table there are purchase details and in another column there are sale details.. I

Re: $$Excel-Macros$$ Pivot Table queries

-- *From: * Anoop K Sharma aks.sharm...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Wed, 30 Oct 2013 11:02:43 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Pivot Table queries Sandeep

Re: $$Excel-Macros$$ Pivot Table queries

@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Pivot Table queries Sandeep please insert required formula using pivot table formula. for this go to OptionsformulaCalculated Field. Options Ribbon will populate once you select the pivot field

Re: $$Excel-Macros$$ Pivot Table Query

place Return type in column Labels . Enjoy Team XLS On Tue, Oct 29, 2013 at 1:38 PM, Pravin Gunjal isk1...@gmail.com wrote: *Hello,* * * *I have created a pivot table for attached file as per column F, I M from Data Sheet. * * * *I want the total of return

$$Excel-Macros$$ Pivot Table queries

Hi, Excel gurus, I want to get a column in a pivot table which is comprising of division of two data-source column. Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Pivot Table queries

Sandeep please insert required formula using pivot table formula. for this go to OptionsformulaCalculated Field. Options Ribbon will populate once you select the pivot field and Calculated field will enable when you select any column field in pivot. On Wed, Oct 30, 2013 at 8:07 AM, Sandeep

Re: $$Excel-Macros$$ Pivot Table queries

: excel-macros@googlegroups.com Date: Wed, 30 Oct 2013 11:02:43 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Pivot Table queries Sandeep please insert required formula using pivot table formula. for this go to OptionsformulaCalculated

RE: $$Excel-Macros$$ Pivot table format

Dear Group plz help From: kashanabbas...@hotmail.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Pivot table format Date: Sat, 26 Oct 2013 09:54:54 +0500 Dear Plz reply From: kashanabbas...@hotmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Pivot

Re: $$Excel-Macros$$ Pivot table format

: RE: $$Excel-Macros$$ Pivot table format Date: Sat, 26 Oct 2013 09:54:54 +0500 Dear Plz reply -- From: kashanabbas...@hotmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Pivot table format Date: Fri, 25 Oct 2013 16:38:19 +0500 Dear Expert

RE: $$Excel-Macros$$ Pivot table format

Dear Plz reply From: kashanabbas...@hotmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Pivot table format Date: Fri, 25 Oct 2013 16:38:19 +0500 Dear Expert , I want to repeat date with every record .Reference sheet is attached for your review . Pleas help Thanks

Re: $$Excel-Macros$$ Pivot Table

try the attachment see if it helps On Sun, Sep 22, 2013 at 10:26 AM, Bv Dileep bvdil...@gmail.com wrote: Hello All, Can any one provide the macro code to make a pivot table -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official

$$Excel-Macros$$ Pivot Table

Hello All, Can any one provide the macro code to make a pivot table -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate

$$Excel-Macros$$ Pivot Table - Cumlative Totals

Hello, Hope everyone is well. I think I have a really simple question but I am struggling! I am looking for a cumlative total across columns, please see example data below: Basically I want the first column in the Pivot table to be the Opening value then the next column to take the opening

Re: $$Excel-Macros$$ Pivot Table - Cumlative Totals

Please do share your file. On Fri, Sep 20, 2013 at 1:34 AM, Brett Manning brettmannin...@gmail.comwrote: Hello, Hope everyone is well. I think I have a really simple question but I am struggling! I am looking for a cumlative total across columns, please see example data below: Basically

Re: $$Excel-Macros$$ Pivot Table Running Balance - Grand Total

Hai Friends, Thank you all for your efforts in giving me a solution. However, I wish to state that I want an advanced solution. What I want is - I already have the Running Balance column and I have to get the Grand Total i.e., the last value of the Running Balance under each Bank in the same

Re: $$Excel-Macros$$ Pivot Table Running Balance - Grand Total

Dear Nath, Pl find the attached herewith. Warm Regards, Gawli Anil On Wed, Aug 14, 2013 at 3:09 PM, Gopinath nath@gmail.com wrote: Dear Shri Satendra Kumar, Thank you for your suggestion. However, what I wanted is Running Balance for each Bank - Datewise as well as Grand Total Balance

Re: $$Excel-Macros$$ Pivot Table Running Balance - Grand Total

Dear Shri Satendra Kumar, Thank you for your suggestion. However, what I wanted is Running Balance for each Bank - Datewise as well as Grand Total Balance available for each Bank, both in One Column of the Pivot Table. Thank you once again for your assistance. Gopinath A K On Tue, Aug 13, 2013

Re: $$Excel-Macros$$ Pivot Table Running Balance - Grand Total

Respected GopiNath, Please check the following youtube video for your answer http://www.youtube.com/watch?v=Rr9dK5bDWcE Regards, Vijaykumar On Wed, Aug 14, 2013 at 3:09 PM, Gopinath nath@gmail.com wrote: Dear Shri Satendra Kumar, Thank you for your suggestion. However, what I wanted

$$Excel-Macros$$ Pivot Table Running Balance - Grand Total

I had attached an Excel file with data and Pivot Table. What I want is the yellow portion is not to be displayed. On the other hand, the Grand Total and Company Total should be displayed under the Running Balance column. Looking for kind assistance please. -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Pivot Table Running Balance - Grand Total

Hi Gopi ji, find attach file. thanks satendra On Tue, Aug 13, 2013 at 5:28 PM, Gopi Nath nath@gmail.com wrote: I had attached an Excel file with data and Pivot Table. What I want is the yellow portion is not to be displayed. On the other hand, the Grand Total and Company Total should

Re: $$Excel-Macros$$ PIVOT TABLE FROM MULTIPLE SHEETS

*Subject:* $$Excel-Macros$$ PIVOT TABLE FROM MULTIPLE SHEETS ** ** Respected Experts, ** ** Is it possible to create a pivot table taking data (or fields) from different sheets of the workbook. ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** Regards

$$Excel-Macros$$ PIVOT TABLE FROM MULTIPLE SHEETS

Respected Experts, Is it possible to create a pivot table taking data (or fields) from different sheets of the workbook. Regards, P.VIJAY KUMAR -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum

RE: $$Excel-Macros$$ Pivot table

17:24 To: excel-macros@googlegroups.com Cc: gawlianil8...@gmail.com Subject: Re: $$Excel-Macros$$ Pivot table need more explanation . Enjoy Team XLS On Mon, Mar 25, 2013 at 6:00 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.ukmailto:manjunath.narayana

Re: $$Excel-Macros$$ Pivot table

-macros@googlegroups.com *Cc:* gawlianil8...@gmail.com *Subject:* Re: $$Excel-Macros$$ Pivot table need more explanation . Enjoy Team XLS On Mon, Mar 25, 2013 at 6:00 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.uk wrote: Dear Anil, Further

RE: $$Excel-Macros$$ Pivot table

But every day i need to run report update in fresh spreadsheet From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of xlstime Sent: 26 March 2013 12:07 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Pivot table Hi Maniunath, if headers

Re: $$Excel-Macros$$ Pivot table

spreadsheet *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *xlstime *Sent:* 26 March 2013 12:07 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Pivot table Hi Maniunath, if headers are fixed then i think no need

RE: $$Excel-Macros$$ Pivot table

It's not working it shows a syntax error in line From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of xlstime Sent: 26 March 2013 12:44 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Pivot table .. please check below link http

Re: $$Excel-Macros$$ Pivot table

need more explanation . Enjoy Team XLS On Mon, Mar 25, 2013 at 6:00 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.uk wrote: Dear Anil, Further to the above attached, With the help of macros can we run pivot table for the data which is available in

Re: $$Excel-Macros$$ Pivot table

PFA.. On Wed, Jan 9, 2013 at 1:27 PM, Anoop K Sharma aks.sharm...@gmail.comwrote: Hope the attached file can help you better. Regards, Anoop Sr. Developer -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate

Re: $$Excel-Macros$$ Pivot table

Hope the attached file can help you better. Regards, Anoop Sr. Developer -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

Re: $$Excel-Macros$$ Pivot Table - Required percentile values

Thank you Anoop for your hlep but probably for us VBA is a not a solution. Once again many thanks for time and effort. S. On Mon, Nov 19, 2012 at 9:16 AM, Anoop K Sharma aks.sharm...@gmail.comwrote: Possibly, I am getting errors in applying the above criteria. What if I can provide you the

Re: $$Excel-Macros$$ Pivot Table - Required percentile values

Possibly, I am getting errors in applying the above criteria. What if I can provide you the same applying VBA? Regards, Anoop Sr. Developer On Tue, Nov 13, 2012 at 10:55 AM, Sheyn Lee sheyn...@gmail.com wrote: Dear Anoop, I need the values from a pivot table use the formula

Re: $$Excel-Macros$$ Pivot Table - Required percentile values

Dear Anoop, I need the values from a pivot table use the formula '=PERCENTILE(C2:C6,0.5)' Best Regrds, S. On Mon, Nov 12, 2012 at 12:56 PM, Anoop K Sharma aks.sharm...@gmail.comwrote: Sheyn, Please elaborate your query. Regards, Anoop On Sat, Nov 10, 2012 at 2:29 PM, Sheyn Lee

Re: $$Excel-Macros$$ Pivot Table - Required percentile values

Sheyn, Please elaborate your query. Regards, Anoop On Sat, Nov 10, 2012 at 2:29 PM, Sheyn Lee sheyn...@gmail.com wrote: Dear MS Excel Group, Can we get percentile values from a pivot table. Best Regards, Sheyn -- Join official facebook page of this forum @

$$Excel-Macros$$ Pivot Table - Required percentile values

Dear MS Excel Group, Can we get percentile values from a pivot table. Best Regards, Sheyn -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ Pivot Table Vba Help needed

Hi Noorain, You have sent very good file for learning PT with all options in terms of VBA. Can you send same kind of file for Chart as well. Thanks in Advance. On 8/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Kaushik, Please find attached VBA Pivot Table Template, Hope it

Re: $$Excel-Macros$$ Pivot Table Vba Help needed

Hi Noorain, You have sent very good file for learning PT with all options in terms of VBA. Can you send same kind of file for Chart as well. Thanks in Advance. On 9/3/12, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Noorain, You have sent very good file for learning PT with all options in

$$Excel-Macros$$ Pivot Table Vba Help needed

Hi All, *Need your help to perform the attached task.* * * *What I am doing is as below:=* * * *1. I am having the data in the Data tab of the file* *2. I want to create the Pivot table based on the Data tab with Criteria as Row Labels: Supplier and Values: Sum of Amount.* *3. Then I want to

$$Excel-Macros$$ Pivot table with chart represent

Hi, I have recorded th macro for creating pivot table with pivot chart for the 1st time and running for 2nd time gives me an error - Run time error 5 Please help in changing the *vba* code as shows in Sheet(Summary) with 1 click button to go. Request everyone to pls have this resolved asap.

Re: $$Excel-Macros$$ Pivot table with chart represent

hi why do u want to use vba . simple make the dynamic range and add it to the source of pivot whenever u will add or delete the data in source sheet it will automatically get updated try the attachment visit to know more abt http://www.contextures.com/xlPivot01.html On Sun, Jul 29,

$$Excel-Macros$$ Pivot table

i have created a pivot table in excel in sheet 4 out of sheet 1 data. Now i have added a calculation column - right most column of the pivot... now when i delete the row of the data in sheet 1 say mumbai row, and then refresh the pivot... then the last column gets messed up showing div/0 error

Re: $$Excel-Macros$$ Pivot table

Hi, Try this formula, =B4/OFFSET($A$3,COUNTA(A:A)-1,2) Regards, MARIES. On Sun, Apr 15, 2012 at 10:20 PM, Sara Lee lee.sar...@gmail.com wrote: i have created a pivot table in excel in sheet 4 out of sheet 1 data. Now i have added a calculation column - right most column of the pivot...

Re: $$Excel-Macros$$ Pivot table

thanks it is good but one change required--- when i add more records into my base sheet , and then refresh the pivot, that column % does not get updated automatically;; also when i delete records, that column shows up 0 even though there are no records to left On Sun, Apr 15, 2012 at 3:41 PM,

Re: $$Excel-Macros$$ Pivot table

Hi, In that case, Dynamic range is good solution. I have used Name Range rng refers as*=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1)) * Regards, MARIES.* * On Mon, Apr 16, 2012 at 12:14 AM, Sara Lee lee.sar...@gmail.com wrote: thanks it is good but one change required---

Re: $$Excel-Macros$$ Pivot table

Hi So do i have to copy and paste this formula? On Sun, Apr 15, 2012 at 4:32 PM, Maries talk2mar...@gmail.com wrote: Hi, In that case, Dynamic range is good solution. I have used Name Range rng refers as*=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1)) * Regards,

Re: $$Excel-Macros$$ Pivot table

Hi, To get the percentage, *Copy paste* or *Drag Down* the formula from * Sheet1-D4*. On Mon, Apr 16, 2012 at 1:10 AM, Sara Lee lee.sar...@gmail.com wrote: Hi So do i have to copy and paste this formula? On Sun, Apr 15, 2012 at 4:32 PM, Maries talk2mar...@gmail.com wrote: Hi, In

$$Excel-Macros$$ Pivot table

Hi Excel gurus, I have attached excel sheet consisting of pivot table, For second column in the attached sheet I need count. How to achieve this without using Macros. Thanks in advance. KrishDear excelmacros! Get Yourself a cool, short @in.com Email ID now! -- FORUM RULES (986+ members

Re: $$Excel-Macros$$ Pivot table

Dear krishnaraddi, Attached sheet is blank, pls resend On Wed, Mar 21, 2012 at 6:27 PM, Krishnaraddi excelkris...@in.com wrote: Hi Excel gurus, I have attached excel sheet consisting of pivot table, For second column in the attached sheet I need count. How to achieve this without using

Re: $$Excel-Macros$$ Pivot Table

Hi, Check out the below link http://www.contextures.com/CreatePivotTable.html On Tue, Mar 20, 2012 at 2:53 PM, Karan Singh karan1...@gmail.com wrote: Dear All, Kindly send me some pivot table examples. I want to learn it. Thanks Kaяan http://www.facebook.com/singhkarann

Re: $$Excel-Macros$$ Pivot Table

Hi Karan, Try to download *Excel 2007 PivotTables Recipes.pdf * book by 2007 by Debra Dalgleish Or you can search in youtube for Video's tutorial.. *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Tue, Mar 20, 2012 at 2:59 PM,

Re: $$Excel-Macros$$ Pivot Table data range update

Hi, Please use below codes for updates last used row last used column in Pivot Tables. Sheets(Sheet1).Select ActiveWorkbook.Names.Add Name:=Sheet1, RefersToR1C1:= _ =OFFSET(Sheet1!C1,0,0,COUNTA(Sheet1!C1),COUNTA(Sheet1!R1)) ActiveWorkbook.Names(AfterEntry).Comment = Regards,

Re: $$Excel-Macros$$ Pivot Table data range update

Thanks Noorain. That was very thorough. I am using excel 2010 but I can find the Name Manager. I will encourage all our Excel gurus to follow your footsteps. This little tutorial made me like this forum even more!!! Thanks a lot and best regards. On Feb 13, 11:11 pm, NOORAIN ANSARI

Re: $$Excel-Macros$$ Pivot Table data range update

Although I have not tested it on Excel 2010 in Excel 2007 the shortcut key to Name Manager dialog box is Ctrl + F3 I hope it works for 2010 also. As for explanation given by Noorain it's excellent and most complete. You can also achieve this through VBA but it would effect the speed/ performance

$$Excel-Macros$$ Pivot Table data range update

I have code to query a database and return data to the data sheet. The number of rows of data returned will vary. Through VBA code, how do I tell the pivot table to update the range of the source data (which is really to update the last row). (Selecting CTRL-End, goes past where the actual data

$$Excel-Macros$$ Pivot Table from two separate sheets

Hello Friends. I have two sheets For E.g. 1. Opening Balances and purchases of goods 2. Consumption of goods Both the sheets will contain many colours like. purchase date,consumption date, inv. no. party name., item, qty. , values, etc. Now I need to create a Pivot table, in which

Re: $$Excel-Macros$$ Pivot Table from two separate sheets

Hi, can u send a sample data sheet On Fri, Feb 3, 2012 at 6:18 PM, B Sharma sharma@gmail.com wrote: Hello Friends. I have two sheets For E.g. 1. Opening Balances and purchases of goods 2. Consumption of goods Both the sheets will contain many colours like. purchase

Re: $$Excel-Macros$$ Pivot Table from two separate sheets

If you are using excel 2007+ then install this add-in On Fri, Feb 3, 2012 at 6:18 PM, B Sharma sharma@gmail.com wrote: Hello Friends. I have two sheets For E.g. 1. Opening Balances and purchases of goods 2. Consumption of goods Both the sheets will contain many colours

Re: $$Excel-Macros$$ Pivot Table (URGENT)

Hey thanks Priyanka, it workss perfectly the way I wanted to thanks alot :) On Fri, Jan 20, 2012 at 12:20 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Mahreen Kindly find the attached file and see the yellow highlighted row ,i have did the same w/o pivot On Thu, Jan 19, 2012 at 11:12

Re: $$Excel-Macros$$ Pivot Table (URGENT)

You are welcome On Fri, Jan 20, 2012 at 2:23 PM, Mahreen Ellahi mahreen.acc...@gmail.comwrote: Hey thanks Priyanka, it workss perfectly the way I wanted to thanks alot :) On Fri, Jan 20, 2012 at 12:20 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Mahreen Kindly find the attached file

$$Excel-Macros$$ Pivot Table data extract

Hi Expert, In Pivot table data details, when we double click on any value the details of those values extract from main database and another worksheet get prepared. In this process, new worksheet details (extracted one) by default extracted in Table Format and everytime we have to do Convert

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Right Click on the pivot table, select Pivot Tabel Options, move to 'Data' tab and then Uncheck- Enable Show Details. For the date format i think its working fine in both rows n columns. On Thu, Sep 1, 2011 at 10:18 PM, Prabhu prabhugate...@gmail.com wrote: Hi Friends, I think topic got

$$Excel-Macros$$ Pivot Table data extract

Hi Expert, In Pivot table data details, when we double click on any value the details of those values extract from main database and another worksheet get prepared. In this process, new worksheet details (extracted one) by default extracted in Table Format and everytime we have to do Convert

Re: $$Excel-Macros$$ Pivot Table data extract

Right Click on the pivot table, select Pivot Tabel Options, move to 'Data' tab and then Uncheck- Enable Show Details. On Fri, Sep 2, 2011 at 4:44 PM, Anil Bhange anil.bha...@tatacommunications.com wrote: Hi Expert, ** ** In Pivot table data details, when we double click on any value

RE: $$Excel-Macros$$ Pivot Table data extract

-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shaik Waheed Sent: Friday, September 02, 2011 04:54 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Pivot Table data extract Right Click on the pivot table, select Pivot Tabel Options, move to 'Data' tab

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Hi Shaik, When i Uncheck- Enable Show Details, Pivot table is not expanding with the details. Normally if i double click the value of the Pivot table automaticly separate sheet will appear but after unclick the Enable Show Details details not appearing. Can you plz help. Prabhu --

Re: $$Excel-Macros$$ Pivot Table data extract

-Macros$$ Pivot Table data extract ** ** Right Click on the pivot table, select Pivot Tabel Options, move to 'Data' tab and then Uncheck- Enable Show Details. On Fri, Sep 2, 2011 at 4:44 PM, Anil Bhange anil.bha...@tatacommunications.com wrote: Hi Expert, In Pivot

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Hi, Right Click on the pivot table, select Pivot Tabel Options, move to 'Data' tab and then Uncheck- Enable Show Details. For the date format i think its working fine in both rows n columns. Regards, Waheed. On Thu, Sep 1, 2011 at 7:55 AM, Prabhu prabhugate...@gmail.com wrote: HI All, Plz

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Plz put all ur queries n replies to the group id. So that everyone will try n learn, that is wht our objective. Thnx Waheed. On Thu, Sep 1, 2011 at 4:47 PM, John Alliage Tinio Morales alliage.mora...@gmail.com wrote: Thank you very much! Hope we could get in touch soon for future problems on

Re: $$Excel-Macros$$ **Pivot Table Doubt**

*If two geographical data match in two sheets, then add/copy/replicate unique id/code* Hi guys, this is my problem. I have a geographical data (divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN, and BARANGAY/STREET) in one sheet. This sheet contains a UNIQUE GEOGRAPHICAL CODE that

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Sir, I totally confused to put my query in group ID. pls tell me the procedure On Thu, Sep 1, 2011 at 5:58 PM, Shaik Waheed waheedb...@gmail.com wrote: Plz put all ur queries n replies to the group id. So that everyone will try n learn, that is wht our objective. Thnx Waheed. On Thu, Sep

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Hi, Write the correct problem in subject section, like pivot, conditional formatting, lookup function,. and then elaborate the problem as clearly as u can, and also if possible attach the sample sheet. Regards, Waheed. On Thu, Sep 1, 2011 at 7:26 PM, Shankar Bheema shankar.n...@gmail.com wrote:

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Hi Friends, I think topic got changed. Actually i have attached a pivot file, when is double click the numbers a new sheet is appearing. But in that sheet all numbers are shows in date format!!!. Plz help to know the reason and how i can get Numbers in numbers format and date in date format??

$$Excel-Macros$$ **Pivot Table Doubt**

Hi Friends, When i double click my Pivot table value a new sheet is appearing with the details. But all the amount columns are showing in date format. Can anybody help how to rectify the same.(value should show in Number format and date should be in date format) Plz help. Regards, Prabhu

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Subject: $$Excel-Macros$$ **Pivot Table Doubt** Hi Friends, When i double click my Pivot table value a new sheet is appearing with the details. But all the amount columns are showing in date format. Can anybody help how to rectify the same.(value should show in Number format and date should

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Hi Prabhu, Send send some sample data with pivot... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Wed, Aug 31, 2011 at 12:28 PM, Prabhu prabhugate...@gmail.com wrote: Hi Friends, When i double click my Pivot table value a

Re: $$Excel-Macros$$ **Pivot Table Doubt**

HI All, Plz find the pivot table sheet. kindly help. Regards, Prabhu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

$$Excel-Macros$$ Pivot table to remain intact - even if data table is removed

Dear Friend, I am preparing an MIS however to compare the result of MIS I am also preparing few Pivot table. I want to keep the Pivot table selected field intact even if the sheet in the data table is removed. Is that possible? Best Regards, Amit Desai

RE: $$Excel-Macros$$ Pivot table to remain intact - even if data table is removed

[mailto:excel-macros@googlegroups.com] On Behalf Of Amit Desai (MERU) Sent: Monday, August 29, 2011 1:13 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Pivot table to remain intact - even if data table is removed Dear Friend, I am preparing an MIS however to compare the result

RE: $$Excel-Macros$$ Pivot table to remain intact - even if data table is removed

will not effect if Data Table is Removed .. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Amit Desai (MERU) Sent: Monday, August 29, 2011 1:13 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Pivot table to remain intact - even if data table is removed

Re: $$Excel-Macros$$ Pivot table to remain intact - even if data table is removed

:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Rajan_Verma *Sent:* Monday, August 29, 2011 2:02 PM *To:* excel-macros@googlegroups.com *Subject:* RE: $$Excel-Macros$$ Pivot table to remain intact - even if data table is removed ** ** *Pivot table

RE: $$Excel-Macros$$ Pivot Table Percent of Column...

Have a look at the page : http://support.microsoft.com/kb/106359/en-us Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Robert Jacobs Envoyé : jeudi 25 août 2011 16:35 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros

Re: $$Excel-Macros$$ Pivot Table Percent of Column...

[mailto:excel-macros@googlegroups.com] De la part de Robert Jacobs Envoyé : jeudi 25 août 2011 16:35 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ Pivot Table Percent of Column... Thanks in advance experts!!! This is very complicated to explain, but I'll give it a go: I have data

Re: $$Excel-Macros$$ Pivot Table Percent of Column...

: $$Excel-Macros$$ Pivot Table Percent of Column... Thanks in advance experts!!!  This is very complicated to explain, but I'll give it a go: I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3 Sales), and need to find the percent of sales for each category, for each year in my

Re: $$Excel-Macros$$ Pivot Table Percent of Column...

try formula please find attachment... On Thu, Aug 25, 2011 at 8:04 PM, Robert Jacobs robertjacob...@gmail.comwrote: Thanks in advance experts!!! This is very complicated to explain, but I'll give it a go: I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3 Sales), and

$$Excel-Macros$$ Pivot Table Percent of Column...

Thanks in advance experts!!! This is very complicated to explain, but I'll give it a go: I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3 Sales), and need to find the percent of sales for each category, for each year in my data. For instance, if I have: Invoice#Year

$$Excel-Macros$$ Pivot table - show pages as individual workbooks

Hello again - and thanks for the last response, you guys are ace! right have now taken a lot of data relating to clients and have a pivot table, which when i show pages lists 30 worksheets with each one being a separate client and valuation. Is there a way instead of showing the pages as

Re: $$Excel-Macros$$ Pivot table - show pages as individual workbooks

Please attached the sheet or file we could help u then On Thu, Jun 30, 2011 at 9:50 PM, crossy75 sjc5...@yahoo.co.uk wrote: Hello again - and thanks for the last response, you guys are ace! right have now taken a lot of data relating to clients and have a pivot table, which when i show pages

Re: $$Excel-Macros$$ Pivot table - Pivot tabel row Range

Could you tell me what have you done ??? On Sun, Apr 3, 2011 at 8:42 PM, Jaideep Panchal jai.ca...@gmail.com wrote: if it helps... -- Rakesh kumar khowal +91 9868532105 -- -- Some important links for excel

$$Excel-Macros$$ - Pivot table .Calculation = xlPercentOfColumn

Hi Members, Could you tell me where I should put the .Calculation = xlPercentOfColumn .NumberFormat = 0.00% to get desired results 'Define fields in PivotTable With PT ' Reference to Exisiting Pivot Table With .PivotFields(HHSizeGroup) .Orientation = xlRowField

Re: $$Excel-Macros$$ Pivot table - Pivot tabel row Range

Hi Umesh/Group members, I am attaching the sample data. I know if I take gender for column it'll solve the problem, but for some reason I don't wish to add any field in the column.. Thanks ! On Fri, Apr 1, 2011 at 7:07 PM, Umesh Dev umesh.d...@gmail.com wrote: Hi Rakesh, can you attach

Re: $$Excel-Macros$$ Pivot table - Pivot tabel row Range

Hi Rakesh, See if it helps... Regards, Jaideep Panchal New Delhi - Original Message - From: rakesh kumar To: excel-macros@googlegroups.com Sent: Sunday, April 03, 2011 1:44 PM Subject: Re: $$Excel-Macros$$ Pivot table - Pivot tabel row Range Hi Umesh/Group members

  1   2   >