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 e

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" wrote: > Dear All Excel Experts, > From a very long time, I am trying to create a pivot table using two or >

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 tabl

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

> *Date: *Wed, 30 Oct 2013 11:02:43 +0530 > *To: * > *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 Options>formula>Calculated Fiel

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

hhajer > Mumbai > India > > Sent on my BlackBerry® from Vodafone > -- > *From: * Anoop K Sharma > *Sender: * excel-macros@googlegroups.com > *Date: *Wed, 30 Oct 2013 11:02:43 +0530 > *To: * > *ReplyTo: * excel-macros@googlegroups.com >

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

cros@googlegroups.com Date: Wed, 30 Oct 2013 11:02:43 To: 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 Options>formula>Calculated Field. Options Ribbon will populate once

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

Sandeep please insert required formula using pivot table formula. for this go to Options>formula>Calculated 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, Sandee

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 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 types “E

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

all of the formulas have been converted to values. . Enjoy Team XLS On Sun, Oct 27, 2013 at 1:16 AM, Kashan Abbas wrote: > Dear Group plz help > > -- > From: kashanabbas...@hotmail.com > To: excel-macros@googlegroups.com >

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

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 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 Facebook page

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

Please do share your file. On Fri, Sep 20, 2013 at 1:34 AM, Brett Manning wrote: > 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 co

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 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" > available

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 wrote: > Dear Shri Satendra Kumar, > Thank you for your suggestion. However, what I wanted is "Running > Bal

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, 20

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 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 be displayed > un

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

How it is to be used? On Fri, May 17, 2013 at 10:27 AM, Rajan_Verma wrote: > *Use it * > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *P.VIJAYKUMAR > *Sent:* 17 May 2013 10:19 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Ma

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

Re: $$Excel-Macros$$ Pivot table

mp; 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 > > > &g

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

oglegroups.com] *On Behalf Of *xlstime > *Sent:* 25 March 2013 17:24 > *To:* excel-macros@googlegroups.com > *Cc:* gawlianil8...@gmail.com > *Subject:* Re: $$Excel-Macros$$ Pivot table > > > > need more explanation > > . > > Enjoy >

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 mailto:manjunath.narayana...@aon.co.uk>> wrote: Dear Anil, F

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 > a

Re: $$Excel-Macros$$ Pivot table

PFA.. On Wed, Jan 9, 2013 at 1:27 PM, Anoop K Sharma wrote: > > 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.

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 Pro

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 wrote: > Possibly, I am getting errors in applying the above criteria. What if I > can provide you the same applying VBA? > > R

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 wrote: > Dear Anoop, > I need the values from a pivot table use the formula > '=PERCENTILE(C2:C6,0.5)' > > Bes

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 wrote: > Sheyn, Please elaborate your query. > > Regards, > Anoop > > > On Sat, Nov 10, 2012 at 2:29 PM, Sheyn Lee wrote: > >> Dear MS Excel

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 wrote: > 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 >

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 wrote: > Hi Noorain, > > You have sent very good file for learning PT with all options in terms of > VBA. > Can

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 wrote: > Dear Kaushik, > > Please find attached VBA Pivot Table Template, Hope it will help to you. > > --

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, 201

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 wrote: > Hi > > So do i have to copy and paste this formula? > > > On Sun, Apr 15, 2012 at 4:32 PM, Maries wrote: > >> Hi, >> >> In that case, Dynamic range is goo

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 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, > > MARIES. > *

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 wrote: > thanks it is good but one change required--- when i add more rec

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, Ma

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 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... > > now when i delete

Re: $$Excel-Macros$$ Pivot table

Dear krishnaraddi, Attached sheet is blank, pls resend On Wed, Mar 21, 2012 at 6:27 PM, Krishnaraddi 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 > Macros. > > Thanks

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 * On Tue, Mar 20, 2012 at 2:59 PM, S

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 wrote: > Dear All, > > Kindly send me some pivot table examples. I want to learn it. > > > Thanks > Kaяan > >

Re: $$Excel-Macros$$ Pivot table

Hi, This is the third time, you posting the same question. Already issue rectified . *Please check this link:* https://groups.google.com/forum/?fromgroups#!searchin/excel-macros/$20the$20file,$20Where$20i$20am$20using$20recording$20macro..$20and$20get$20the$20pivot$20table$20but$20every$20date$2

Re: $$Excel-Macros$$ Pivot table

Dear Maries, Thats right good one. Thanks & Regards, Prajakt Pande On Mon, Feb 20, 2012 at 1:58 PM, Maries wrote: > *PFA* > > On Thu, Feb 16, 2012 at 10:04 AM, Maries wrote: > >> Hi, >> >> Find the attached file. It will work. >> >> Sheets("NDC").Select >> ActiveWorkbook.Names.Add Na

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 = "" Rega

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 of

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 wrote: > Dear

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 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 da

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 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 date,consumption date

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

You are welcome On Fri, Jan 20, 2012 at 2:23 PM, Mahreen Ellahi wrote: > Hey thanks Priyanka, it workss perfectly the way I wanted to thanks alot :) > > > On Fri, Jan 20, 2012 at 12:20 PM, PrIyAnKa wrote: > >> Dear Mahreen >> >> Kindly find the attached file and see the yellow highlighted row ,i

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 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 PM, Mahreen Ell

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

>> ** ** >> >> *From:* excel-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 Tabl

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

matting. > > ** ** > > Regards,Anil Bhange > > IP Phone - 512320 | Mobile - 90290 32123 > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Shaik Waheed > *Sent:* Friday, September 02, 2011 04

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

rom: excel-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

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

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 wrote: > Hi Friends, > I think topic got changed. Actually i have a

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??

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 wrote: > Sir, > I totally co

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 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 1, 2011 at 4:

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**

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 wrote: > Thank you very much! > > Hope we could get in touch soon for future problems on Excel. Thank you! > > O

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 wrote: > HI All, > Plz find the pivot table sh

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 Li

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

Hi Prabhu, Send send some sample data with pivot... *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Wed, Aug 31, 2011 at 12:28 PM, Prabhu wrote: > Hi Friends, > > When i double click my Pivot table value a new sheet is appearin

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

Can you post the pivoted file plz ? Thanks Prasad Sent from BlackBerry® on Airtel -Original Message- From: Prabhu Sender: excel-macros@googlegroups.com Date: Wed, 31 Aug 2011 12:28:10 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ **Pivot Table Doubt** Hi Friend

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

** > > ** ** > > *From:* 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 i

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

Excel-Macros$$ Pivot table to remain intact - even if data table is removed Pivot table has a cache Memory which holds all the data of Data Table if data table is removed , Pivot table can not be refreshed. but you can get all data from Pivot table, it means Data Stored in Pivot table wil

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

Pivot table has a cache Memory which holds all the data of Data Table if data table is removed , Pivot table can not be refreshed. but you can get all data from Pivot table, it means Data Stored in Pivot table will not effect if Data Table is Removed .. From: excel-macros@googlegroups.com [mai

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

try formula please find attachment... On Thu, Aug 25, 2011 at 8:04 PM, Robert Jacobs wrote: > 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 pe

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

Thanks to everybody for their suggestions. Fred - I couldn't layout my data the way you suggested, just due to the sheer number of rows it would have created. The data I provided was a joke compared to what is actually listed, and the number of categories is much, much more than the 3 I gave in m

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

Hi please find the attachment it may help -- *Great day,* *viper * On Fri, Aug 26, 2011 at 2:13 PM, Daniel wrote: > 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-mac

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$$ P

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 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 lists 30 worksh

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 wrote: > if it helps... -- Rakesh kumar khowal +91 9868532105 -- -- Some important links for excel users: 1. Follow u

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

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 wrote: > Hi Rakesh, > > can you attach the excel sheet > >

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

Hi Rakesh, can you attach the excel sheet Regards Umesh Dev On Fri, Apr 1, 2011 at 4:29 PM, rakesh kumar wrote: > Hi ! Group members, > > I have a pivot table, which shows 5 income groups in row Range and their > counts. However, when I apply a filter it leaves 3 income groups in the row > rang

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

Thank you Ashish and Viswanathan very much. Problem solved. John On Sun, Mar 27, 2011 at 2:28 AM, ashish koul wrote: > check the attachment see if it helps > > > On Sun, Mar 27, 2011 at 11:18 AM, ashish koul wrote: > >> >> >> On Sun, Mar 27, 2011 at 5:51 AM, Viswanathan M wrote: >> >>> Dear

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

Dear Mr. John, =SUM(NOT(B2=""),NOT(D2=""),NOT(F2="")) The above formula will help you for finding out the Total Deliveries *With warm regards* *Viswanathan M* DE(Tech) RGM TTC Chennai-600027 *Vande* *Mataram* On Sat, Mar 26, 2011 at 9:57 PM, John A. Smith wrote: > I have an excel database

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

Thanks!!! Anil, Its working great!! Regards, Deepak On Tue, Feb 1, 2011 at 11:58 AM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > Hi Deepak, > > > > Please find the reply to your queries. > > > > Regards,Anil Bhange > > IP Phone - 512320 | Mobile - 90290 32123 > > > > *From:*

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

Hi Deepak, Please find the reply to your queries. Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Deepak Rawat Sent: Tuesday, February 01, 2011 11:11 AM To: excel-macros@googlegroups.com Sub

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

Thanx!! Flemos On Sat, Aug 7, 2010 at 2:50 PM, Deepak Rawat wrote: > Hi all > > I have attached a file containg pivot table with some data. > I have two qurries > 1. I want to put a foruma next to pivot table and want to copy and paste > all formula to all rows but its taking freezing cells by

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

Hi Deepak Rawat, You can create a calculated pivot field. it´s possible by accessing Options tab (when selected a pivot table cell) and click on formulas button. I´ve created the formula in the attached file. Regards, FLemos. 2010/8/7 Deepak Rawat > Hi all > > I have attached a file containg

Re: $$Excel-Macros$$ Pivot table problem Pls help me

Thanks a Lot I have done that.. On Tue, Jul 27, 2010 at 6:32 PM, Venkatesh Narla wrote: > Dear All, > I have problem in 2007 Excel Pivot table > Pls find the Pictures. > > > Best Regards, > Venkatesh narla, > 9886058917 > > -- >

Re: $$Excel-Macros$$ Pivot table problem Pls help me

Hi Venkatesh, Solution for your problem. Right click on pivot - Pivot Table option - Display - classic pivot table option(check this option). Let me know if it works On Tue, Jul 27, 2010 at 6:32 PM, Venkatesh Narla wrote: > Dear All, > I have problem in 2007 Excel Pivot table > Pls find the P

Re: $$Excel-Macros$$ Pivot table problem Pls help me

hey venkatesh, both are one and the same wt is your excat problam in that. Can u please eleabrate? or give me the sample file. On 7/27/10, Venkatesh Narla wrote: > > Dear All, > I have problem in 2007 Excel Pivot table > Pls find the Pictures. > > > Best Regards, > Venkatesh narla, > 9886058917

Re: $$Excel-Macros$$ Pivot table problem Pls help me

Hi Venkatesh, Please right click on Pivot Table & Cilcik On Pivot Table Options Then Cilck on display & Cick On Classic Pivot Table layout & Ok Thanks & Regards Anil Kumar On Tue, Jul 27, 2010 at 6:32 PM, Venkatesh Narla wrote: > Dear All, > I have problem in 2007 Excel Pivot table > Pls fi

Re: $$Excel-Macros$$ Pivot table not showing

Hi Friends Thanx for ur kind reply. Deepak On Fri, Jun 18, 2010 at 8:45 AM, Vijay Aggarwal wrote: > hi Deepak, > > This file has been shared. Please remove sharing (tools-->share workbook) > and then Pivot will start working. > > regards, > Vijay > > On Wed, Jun 16, 2010 at 10:59 PM, Deepak R

Re: $$Excel-Macros$$ Pivot table not showing

hi Deepak, This file has been shared. Please remove sharing (tools-->share workbook) and then Pivot will start working. regards, Vijay On Wed, Jun 16, 2010 at 10:59 PM, Deepak Rawat wrote: > Hi friends, > > I got an excel file, in which pivot table option is disable and not > working. But i am

Re: $$Excel-Macros$$ Pivot table not showing

Hi, This file is shared. you will have to remove this.. Go to Tools-> share work book-> uncheck the ' allow changes' -> ok Regards, Mathan On Thu, Jun 17, 2010 at 11:29 AM, Deepak Rawat wrote: > Hi friends, > > I got an excel file, in which pivot table option is disable and not > working.

Re: $$Excel-Macros$$ Pivot table for Datewise Bank Balance

good On Wed, Jun 2, 2010 at 4:52 PM, prabhakar thakur wrote: > Dear, > Please find the attached your query. > Thanks, > Prabhakar Thakur > New Delhi > +919953736776 > > > > > On Wed, Jun 2, 2010 at 12:37 PM, Ashish Khandelwal > <4everash...@gmail.com>wrote: > >> Dear friend

Re: $$Excel-Macros$$ Pivot Table Help - Gross Margin % & % of Sales

here you go http://www.mediafire.com/download.php?nvt1ymtzjdy thanks for your help! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

Re: $$Excel-Macros$$ Pivot Table Help - Gross Margin % & % of Sales

Guru, I actually want to see both of those line items as percentages of sales which is to say, take gross margin $ and divide it by sales. Same for operating income. Thanks! -- -- Some important links for excel user

Re: $$Excel-Macros$$ Pivot Table Help - Gross Margin % & % of Sales

Hi, Just see the attached file and confirm If this is what you are looking for. Best Regards, Guru On Tue, May 4, 2010 at 8:57 PM, dza7 wrote: > Hello, > > I have a challenging pivot table issue that I hope I can get some help > on. > > Here is the spreadsheet I'm working with: > https://www.y

Re: $$Excel-Macros$$ Pivot Table Help - Gross Margin % & % of Sales

Dvpetta, Can you upload a 2003 version, i may be able to give a thought on it CC me in, so that i know that you have uploaded the sheet Cheers Harry On May 4, 8:27 pm, dza7 wrote: > Hello, > > I have a challenging pivot table issue that I hope I can get some help > on. > > Here is the spreads

RE: $$Excel-Macros$$ Pivot Table - Prevent to add/remove fields except page field

:45:03 +0530 Subject: Re: $$Excel-Macros$$ Pivot Table - Prevent to add/remove fields except page field From: dilipan...@gmail.com To: excel-macros@googlegroups.com CC: cecic...@hotmail.com Hi Cecilia, Try the solution attached with this email. You need to apply the protection to the spreadsheet

Re: $$Excel-Macros$$ Pivot Table - Prevent to add/remove fields except page field

Hi Cecilia, Try the solution attached with this email. You need to apply the protection to the spreadsheet and just need to check the checkboxes as shown in the solution. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo

Re: $$Excel-Macros$$ pivot table help for pos

Hello Dear, I have already viewed your problem. please respond that what you want in pivot column and in pivot row. Please reply so that we can prepare exact pivot. Hope It Will Help Happy To Help :) Shyam On Fri, Mar 12, 2010 at 5:25 PM, satya narayana wrote: > > > -- Forwarde

Re: $$Excel-Macros$$ Pivot table output to pdf with multiple page fields

Dear TheoMa, one suggestion here:- Install Adobe Acrobat professional and then you can convert the each page output as PDF in a single click. Let me know if other information is required on this line. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744 dilipan

  1   2   >