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

[Prabhu Pinky]

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 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 Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Pivot Table Question

[goodman]

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 would appreciate any assistance.
Thank you all.

Adam 100 
Adam 10 
Banana 200 
Banana 20 
Charles 300 
Charles 30 
Eve 400 
Eve 40 
John 500 
John 50 

-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

[TheExpat Wanderer]

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 below the last ones.
 
please help.
 

-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

['Ty' via MS EXCEL AND VBA MACROS]

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 
source data column and description
Problem #2:  I was attempting to use the Color Macro for 2 days w/ no luck 
while placing the colors in other blocks outside of the pivot.  It worked 
outside of the pivot table.
Problem after using debug: conditional formatting. It is displaying 
"#VALUE!" in the box.   

Debug.Print CellColor.address
Debug.Print CellColor.Interior.ColorIndex
Stop

Any ideas on why the Color Macro is not working.  The Macro is down below.

What can I do to get this to work?


Thanks,

Ty


Here is the Macro:


Function CountByColor(CellColor As Range, CountRange As Range)
Application.Volatile
Dim ICol As Integer
Dim TCell As Range
ICol = CellColor.Interior.ColorIndex
For Each TCell In CountRange
If ICol = TCell.Interior.ColorIndex Then
CountByColor = CountByColor + 1
End If
Next TCell
End Function

-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

[saravanan R]

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 and
chart, i need macro to automate these task.

thanks in advance.

Thanks  Regards,

*Saravanan Raju*

Mob: +91 8807708842

+91 9449716334

-- 
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 thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups
MS EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

[saravanan R]

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 and
chart, i need macro to automate these task.

thanks in advance.

Thanks  Regards,

*Saravanan Raju*

Mob: +91 8807708842

+91 9449716334

-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

[B Sharma]

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 each other. 
2. What you will do when you have 5000 nos. of purchases and more than 2 
000 invoices of sale. Then you will not keep one sheet for both the 
transactions.

I have prepared a very well planned excel program to monitor automatically 
all the finance / tax  accounts related work and my nos of sheets are very 
high. I want to minimize this by way of getting consolidated report through 
pivot.

Thanks once again.

BS

On Friday, March 13, 2015 at 7:59:51 PM UTC+5:30, André D'Avila wrote:

 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 recommend to create a 
 macro to copy and paste each table constantly.

 I attached an exemple.



 André Luiz D´Avila

 2015-03-13 10:41 GMT-03:00 B Sharma sharm...@gmail.com javascript::

 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 want a combined pivot table which can show both the details at once 
 with showing closing balances.

 A small database is attached for your reference.
 I have searched a lot. The reference website is also not as per my needs 
 as pivot table can be created but the result cannot be merged.
 Thanks in advance.


 BS
 --
  Consolidate multiple worksheets into one PivotTable report 
 https://support.office.com/en-au/article/Consolidate-multiple-worksheets-into-one-PivotTable-report-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5

 -- 
 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 thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.
  
 NOTE : Don't ever post confidential data in a workbook. Forum owners and 
 members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google Groups 
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to excel-macros...@googlegroups.com javascript:.
 To post to this group, send email to excel-...@googlegroups.com 
 javascript:.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.




-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

[André D'Avila]

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 recommend to create a
macro to copy and paste each table constantly.

I attached an exemple.



André Luiz D´Avila

2015-03-13 10:41 GMT-03:00 B Sharma sharma@gmail.com:

 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 want a combined pivot table which can show both the details at once with
 showing closing balances.

 A small database is attached for your reference.
 I have searched a lot. The reference website is also not as per my needs
 as pivot table can be created but the result cannot be merged.
 Thanks in advance.


 BS
 --
  Consolidate multiple worksheets into one PivotTable report
 https://support.office.com/en-au/article/Consolidate-multiple-worksheets-into-one-PivotTable-report-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5

 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Pivot Table from multiple tables.xlsx
Description: MS-Excel 2007 spreadsheet

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

[Swapnil Palande]

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 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 want a combined pivot table which can show both the details at once with
 showing closing balances.

 A small database is attached for your reference.
 I have searched a lot. The reference website is also not as per my needs
 as pivot table can be created but the result cannot be merged.
 Thanks in advance.


 BS
 --
  Consolidate multiple worksheets into one PivotTable report
 https://support.office.com/en-au/article/Consolidate-multiple-worksheets-into-one-PivotTable-report-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5

 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

[B Sharma]

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 want a combined pivot table which can show both the details at once with 
showing closing balances.

A small database is attached for your reference.
I have searched a lot. The reference website is also not as per my needs as 
pivot table can be created but the result cannot be merged.
Thanks in advance.


BS
--
 Consolidate multiple worksheets into one PivotTable report 
https://support.office.com/en-au/article/Consolidate-multiple-worksheets-into-one-PivotTable-report-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5

-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Pivot Table from multiple tables.xlsx
Description: MS-Excel 2007 spreadsheet

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

[Dileep Kumar]

Hi Sandeep,

Anoop's earlier suggestion will help you in this also. There is two options
 in OptionsformulaCalculated Field  Calculated Item by using these two
options you can create your own formula in pivot table and resulting field
will also be a part of pivot table.


On Wed, Oct 30, 2013 at 11:15 AM, Sandeep Kumar Chhajer 
chhajersand...@gmail.com wrote:

 **
 Thanks Anup for your response.
 One more thing I want to ask is there any way I can use two column of
 Pivot table for any type of calculation (i.e. the calculation also become
 part of. Pivot table.)
 Suppose, with a data set I have derived with two column in a Pivot table,
 say one is sum and other being count, now I want to work with this two
 column i.e. Sum column / count column with in pivot table, Is it possible?
 Thanks  Regards,
 Sandeep Kumar Chhajer
 Mumbai
 India

 Sent on my BlackBerry® from Vodafone
 --
 *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 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 Kumar Chhajer 
 chhajersand...@gmail.com wrote:

 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
 =TIME(2,DO:IT,N:OW) ! 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 Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE  : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




 --
 Regards,
 Anoop
 Sr. Developer
 Facebook ID - https://www.facebook.com/anooop.k.sharma

 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing

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

[Anoop K Sharma]

yes, you can play with operators (+,-,/,*) with predefined fields to create
new one of your choice.


On Wed, Oct 30, 2013 at 11:15 AM, Sandeep Kumar Chhajer 
chhajersand...@gmail.com wrote:

 **
 Thanks Anup for your response.
 One more thing I want to ask is there any way I can use two column of
 Pivot table for any type of calculation (i.e. the calculation also become
 part of. Pivot table.)
 Suppose, with a data set I have derived with two column in a Pivot table,
 say one is sum and other being count, now I want to work with this two
 column i.e. Sum column / count column with in pivot table, Is it possible?
 Thanks  Regards,
 Sandeep Kumar Chhajer
 Mumbai
 India

 Sent on my BlackBerry® from Vodafone
 --
 *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 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 Kumar Chhajer 
 chhajersand...@gmail.com wrote:

 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
 =TIME(2,DO:IT,N:OW) ! 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 Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE  : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




 --
 Regards,
 Anoop
 Sr. Developer
 Facebook ID - https://www.facebook.com/anooop.k.sharma

 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss

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

[xlstime]

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 types “Expiry, Damage/Breakage, Near Expiry”
 in a first column (column B) and “Saleable” in second column (column C) of
 pivot table.*

 * *

 *Return Type*

 Saleable

 Expired

 Damage/Breakage

 Near Expiry

 * *

 *Could anyone help me out on this.  Thanks in advance !!*

 * *

 

 * *

 *With regards,**
 **Pravin Gunjal*

  --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.


-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.
image001.jpg

$$Excel-Macros$$ Pivot Table queries

[Sandeep Kumar Chhajer]

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 
=TIME(2,DO:IT,N:OW) ! 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 Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

[Anoop K Sharma]

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 Kumar Chhajer 
chhajersand...@gmail.com wrote:

 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
 =TIME(2,DO:IT,N:OW) ! 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 Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE  : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
Regards,
Anoop
Sr. Developer
Facebook ID - https://www.facebook.com/anooop.k.sharma

-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

[Sandeep Kumar Chhajer]

Thanks Anup for your response. 
One more thing I want to ask is there any way I can use two column of Pivot 
table for any type of calculation (i.e. the calculation also become part of. 
Pivot table.)
Suppose, with a data set I have derived with two column in a Pivot table, say 
one is sum and other being count, now I want to work with this two column i.e. 
Sum column / count column with in pivot table, Is it possible?   
Thanks  Regards,
Sandeep Kumar Chhajer
Mumbai
India 

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Anoop K Sharma aks.sharm...@gmail.com
Sender: 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 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 Kumar Chhajer 
chhajersand...@gmail.com wrote:

 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
 =TIME(2,DO:IT,N:OW) ! 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 Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE  : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
Regards,
Anoop
Sr. Developer
Facebook ID - https://www.facebook.com/anooop.k.sharma

-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group

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

[Kashan Abbas]

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

Kashi .

 
  





-- 

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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Jobs posting is not allowed.

6) Sharing copyrighted material and their links is not allowed.

 

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.

--- 

You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.

To post to this group, send email to excel-macros@googlegroups.com.

Visit this group at http://groups.google.com/group/excel-macros.

For more options, visit https://groups.google.com/groups/opt_out.
  





-- 

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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Jobs posting is not allowed.

6) Sharing copyrighted material and their links is not allowed.

 

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.

--- 

You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.

To post to this group, send email to excel-macros@googlegroups.com.

Visit this group at http://groups.google.com/group/excel-macros.

For more options, visit https://groups.google.com/groups/opt_out.
  

-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

[xlstime]

not possible in pivot table

use separately

   1.

   Select the range that contains blank cells you need to fill.
   2.

   Click Home  Find  Select  Go To Special…, and a Go To Special dialog
   box will appear, then check Blanks option.
   3.

   Click OK, and all of the blank cells have been selected. Then input the
   formula “=B2” into active cell B3 without changing the selection. This cell
   reference can be changed as you need.
   4.

   Press Ctrl + Enter, Excel will copy the respective formula to all blank
   cells.
   5.

   At this point, the filled contents are formulas, and we need to convert
   the formals to values. Then select the whole range, right-click to choose
   Copy, and then press Ctrl + Alt + V to active the Paste Special… dialog
   box. And select Values option from Paste, and select None option from
   Operation.
   6.

   Then click OK. And all of the formulas have been converted to values.



.

Enjoy
Team XLS



On Sun, Oct 27, 2013 at 1:16 AM, Kashan Abbas kashanabbas...@hotmail.comwrote:

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

 Kashi .



 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you

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

[Kashan Abbas]

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.

Kashi .

 
  





-- 

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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Jobs posting is not allowed.

6) Sharing copyrighted material and their links is not allowed.

 

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.

--- 

You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.

To post to this group, send email to excel-macros@googlegroups.com.

Visit this group at http://groups.google.com/group/excel-macros.

For more options, visit https://groups.google.com/groups/opt_out.
  

-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Pivot Table

[ashish koul]

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 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 Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on 
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com/groups/163491717053198/


P Before printing, think about the environment.

-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


Pivot Table Sample.xlsm
Description: Binary data

$$Excel-Macros$$ Pivot Table

[Bv Dileep]

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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

[Brett Manning]

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 and add today's entries to 
provide a cumlative balance.

Excel Data

Name TypeOpeningMovement 
1   Movement 2
My AccountBalance   100.00  
100.00   100.00
Dave's Account   Balance200.00  
-100.00  100.00


I would like the Pivot table to display the Opening in the first value 
column in the pivot table as 100.00 for my account and 200.00 for Dave's 
account.  The 2nd Column for Movement 1 should display 200.00 for My 
Account (Opening + Movement) and Movement 2 should total 300.00 (Opening + 
Movement 1 + Movement 2 / or a cumlative running total.

Please can offer me some advice, I am sure this is really simple I just 
cannot work it out.

Thanks,
Brett

   



 




 




 

-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

[Anoop K Sharma]

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 I want the first column in the Pivot table to be the Opening
 value then the next column to take the opening and add today's entries to
 provide a cumlative balance.

 Excel Data

 Name TypeOpeningMovement
 1   Movement 2
 My AccountBalance   100.00
 100.00   100.00
 Dave's Account   Balance200.00
 -100.00  100.00


 I would like the Pivot table to display the Opening in the first value
 column in the pivot table as 100.00 for my account and 200.00 for Dave's
 account.  The 2nd Column for Movement 1 should display 200.00 for My
 Account (Opening + Movement) and Movement 2 should total 300.00 (Opening +
 Movement 1 + Movement 2 / or a cumlative running total.

 Please can offer me some advice, I am sure this is really simple I just
 cannot work it out.

 Thanks,
 Brett
















  --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
Regards,
Anoop
Sr. Developer
Facebook ID - https://www.facebook.com/anooop.k.sharma

-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

[Gopinath]

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 column.
Thank you all for your time.
Regards, Gopinath.


On Fri, Aug 16, 2013 at 10:03 AM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:

  [image: Boxbe] https://www.boxbe.com/overview gawlianil8886@gmail.comis 
 not on your
 Guest 
 Listhttps://www.boxbe.com/approved-list?tc_serial=14887882821tc_rand=376535948utm_source=stfutm_medium=emailutm_campaign=ANNO_MWTPutm_content=001token=DPwUY1dG6RFWm0%2FF35vP3u%2FeWIyRUgAFsM%2FJWc%2B8hMvuiwtGvu9hpSgn%2BSzVZVJFkey=nNO%2F5f5uocSxrwVqcwIhHWkcAbCJBZ577XXdxG6mpJc%3D|
  Approve
 senderhttps://www.boxbe.com/anno?tc_serial=14887882821tc_rand=376535948utm_source=stfutm_medium=emailutm_campaign=ANNO_MWTPutm_content=001token=DPwUY1dG6RFWm0%2FF35vP3u%2FeWIyRUgAFsM%2FJWc%2B8hMvuiwtGvu9hpSgn%2BSzVZVJFkey=nNO%2F5f5uocSxrwVqcwIhHWkcAbCJBZ577XXdxG6mpJc%3D|
  Approve
 domainhttps://www.boxbe.com/anno?tc_serial=14887882821tc_rand=376535948utm_source=stfutm_medium=emailutm_campaign=ANNO_MWTPutm_content=001domtoken=DPwUY1dG6RFWm0%2FF35vP3u%2FeWIyRUgAFsM%2FJWc%2B8hMvuiwtGvu9hpSgn%2BSzVZVJFkey=nNO%2F5f5uocSxrwVqcwIhHWkcAbCJBZ577XXdxG6mpJc%3D

 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
 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 at 5:40 PM, Satendra kumar 
 satendrakuma...@gmail.com wrote:

 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 be
 displayed under the Running Balance column.
 Looking for kind assistance please.

 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




 --
 Thanks  Regards
 Satendra 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 @
 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 Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to a topic in the
 Google Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this topic, visit
 https://groups.google.com/d/topic/excel-macros/0Yibyryyan8/unsubscribe.
 To unsubscribe from this group and all its topics, send an email to
 excel-macros+unsubscr...@googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.






 --
 A K Gopinath
 Plot No.16, Rafi Nagar
 Rear 

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
 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 at 5:40 PM, Satendra kumar satendrakuma...@gmail.com
  wrote:

 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 be displayed
 under the Running Balance column.
 Looking for kind assistance please.

 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




 --
 Thanks  Regards
 Satendra 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 @
 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 Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to a topic in the
 Google Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this topic, visit
 https://groups.google.com/d/topic/excel-macros/0Yibyryyan8/unsubscribe.
 To unsubscribe from this group and all its topics, send an email to
 excel-macros+unsubscr...@googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.






 --
 A K Gopinath
 Plot No.16, Rafi Nagar
 Rear Salamathnagar Tank
 Walaja - 632 513
 Vellore District, T.N.

 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
Thanks  Regards,
Gawli Anil Narayan
Software Developer,
Abacus 

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

[Gopinath]

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 at 5:40 PM, Satendra kumar
satendrakuma...@gmail.comwrote:

 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 be displayed
 under the Running Balance column.
 Looking for kind assistance please.

 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




 --
 Thanks  Regards
 Satendra 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 @
 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 Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to a topic in the
 Google Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this topic, visit
 https://groups.google.com/d/topic/excel-macros/0Yibyryyan8/unsubscribe.
 To unsubscribe from this group and all its topics, send an email to
 excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.






-- 
A K Gopinath
Plot No.16, Rafi Nagar
Rear Salamathnagar Tank
Walaja - 632 513
Vellore District, T.N.

-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

[P.VIJAYKUMAR]

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 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 at 5:40 PM, Satendra kumar satendrakuma...@gmail.com
  wrote:

 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 be displayed
 under the Running Balance column.
 Looking for kind assistance please.

 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




 --
 Thanks  Regards
 Satendra 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 @
 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 Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to a topic in the
 Google Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this topic, visit
 https://groups.google.com/d/topic/excel-macros/0Yibyryyan8/unsubscribe.
 To unsubscribe from this group and all its topics, send an email to
 excel-macros+unsubscr...@googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.






 --
 A K Gopinath
 Plot No.16, Rafi Nagar
 Rear Salamathnagar Tank
 Walaja - 632 513
 Vellore District, T.N.

 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

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

[Gopi Nath]

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 =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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


BankBook.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

[Satendra kumar]

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 be displayed
 under the Running Balance column.
 Looking for kind assistance please.

 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
Thanks  Regards
Satendra 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 @ 
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 Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




BankBook.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

[Amit Gandhi]

How it is to be used?


On Fri, May 17, 2013 at 10:27 AM, Rajan_Verma rajanverma1...@gmail.comwrote:

 *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-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 @
 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 Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.

  

 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.






-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

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

[P.VIJAYKUMAR]

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 @ 
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 Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

RE: $$Excel-Macros$$ Pivot table

[Manjunath Narayanappa]

Dear Experts

Everyday I need to create pivot table to find the Age of each case( Query , 
WIP, untouched, draft) Is there any way to assign macro to the report

Thanks
Manjunath

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.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
Team XLS

On Mon, Mar 25, 2013 at 6:00 PM, Manjunath Narayanappa 
manjunath.narayana...@aon.co.ukmailto: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 sheet1  extract same to sheet 2(Pivot table) So I can find the age of the 
case .
In sheet 2 from pivot table can we pulling same information to DSR(which is 
highlight in Pink)

Thanks
Manjunath



PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL



For Aon's standard conditions associated with this e-mail please visit 
http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp

Aon UK Limited

Registered Office: 8 Devonshire Square, London EC2M 4PL

Registered in London No. 210725 . VAT Registration No. 480 8401 48



Aon UK Limited is authorised and regulated by the Financial Services Authority 
in respect of insurance mediation activities only.
--
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
excel-macros+unsubscr...@googlegroups.commailto:excel-macros%2bunsubscr...@googlegroups.com.
To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.



--
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.





PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL



For Aon's standard conditions associated with this e-mail please visit 
http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp

Aon UK Limited

Registered Office: 8 Devonshire Square, London EC2M 4PL

Registered in London No. 210725 . VAT Registration No. 480 8401 48



Aon UK Limited is authorised and regulated by the Financial Services Authority 
in respect of insurance mediation activities only.

-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions

Re: $$Excel-Macros$$ Pivot table

[xlstime]

Hi Maniunath,

if headers are fixed then i think no need for create pivot-table on daily..
just refresh pivot daily ...

.

Enjoy
Team XLS



On Tue, Mar 26, 2013 at 3:42 PM, Manjunath Narayanappa 
manjunath.narayana...@aon.co.uk wrote:

  Dear Experts



 Everyday I need to create pivot table to find the Age of each case( Query
 , WIP, untouched, draft) Is there any way to assign macro to the report



 Thanks

 Manjunath



 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.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
 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 sheet1  extract same to sheet 2(Pivot table) So I can find
 the age of the case .

 In sheet 2 from pivot table can we pulling same information to DSR(which
 is highlight in Pink)



 Thanks

 Manjunath


  --


 PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL



 For Aon’s standard conditions associated with this e-mail please visit
 http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp

 Aon UK Limited

 Registered Office: 8 Devonshire Square, London EC2M 4PL

 Registered in London No. 210725 . VAT Registration No. 480 8401 48



 Aon UK Limited is authorised and regulated by the Financial Services
 Authority in respect of insurance mediation activities only.

 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.





 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.



 --

 PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL



 For Aon’s standard conditions associated with this e-mail please visit
 http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp

 Aon UK Limited

 Registered Office: 8 Devonshire Square, London EC2M 4PL

 Registered in London No. 210725 . VAT Registration No. 480 8401 48



 Aon UK Limited is authorised and regulated by the Financial Services
 Authority in respect of insurance mediation activities only.

 --
 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 thread titles

RE: $$Excel-Macros$$ Pivot table

[Manjunath Narayanappa]

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 are fixed then i think no need for create pivot-table on daily.. 
just refresh pivot daily ...

.

Enjoy
Team XLS

On Tue, Mar 26, 2013 at 3:42 PM, Manjunath Narayanappa 
manjunath.narayana...@aon.co.ukmailto:manjunath.narayana...@aon.co.uk wrote:
Dear Experts

Everyday I need to create pivot table to find the Age of each case( Query , 
WIP, untouched, draft) Is there any way to assign macro to the report

Thanks
Manjunath

From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com 
[mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On 
Behalf Of xlstime
Sent: 25 March 2013 17:24
To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com
Cc: gawlianil8...@gmail.commailto: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...@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 sheet1  extract same to sheet 2(Pivot table) So I can find the age of the 
case .
In sheet 2 from pivot table can we pulling same information to DSR(which is 
highlight in Pink)

Thanks
Manjunath



PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL



For Aon's standard conditions associated with this e-mail please visit 
http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp

Aon UK Limited

Registered Office: 8 Devonshire Square, London EC2M 4PL

Registered in London No. 210725 . VAT Registration No. 480 8401 48



Aon UK Limited is authorised and regulated by the Financial Services Authority 
in respect of insurance mediation activities only.
--
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
excel-macros+unsubscr...@googlegroups.commailto:excel-macros%2bunsubscr...@googlegroups.com.
To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.



--
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
excel-macros+unsubscr...@googlegroups.commailto:excel-macros%2bunsubscr...@googlegroups.com.
To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.





PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL



For Aon's standard conditions associated with this e-mail please visit 
http://www.aon.com/uk/en

Re: $$Excel-Macros$$ Pivot table

[xlstime]

..

please check below link

http://vbadud.blogspot.in/2008/05/create-pivot-table-using-excel-vba.html
.

Enjoy
Team XLS



On Tue, Mar 26, 2013 at 5:51 PM, Manjunath Narayanappa 
manjunath.narayana...@aon.co.uk wrote:

  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 are fixed then i think no need for create pivot-table on
 daily.. just refresh pivot daily ...


  .

 Enjoy
 Team XLS



 On Tue, Mar 26, 2013 at 3:42 PM, Manjunath Narayanappa 
 manjunath.narayana...@aon.co.uk wrote:

 Dear Experts



 Everyday I need to create pivot table to find the Age of each case( Query
 , WIP, untouched, draft) Is there any way to assign macro to the report



 Thanks

 Manjunath



 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.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
 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 sheet1  extract same to sheet 2(Pivot table) So I can find
 the age of the case .

 In sheet 2 from pivot table can we pulling same information to DSR(which
 is highlight in Pink)



 Thanks

 Manjunath


  --


 PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL



 For Aon’s standard conditions associated with this e-mail please visit
 http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp

 Aon UK Limited

 Registered Office: 8 Devonshire Square, London EC2M 4PL

 Registered in London No. 210725 . VAT Registration No. 480 8401 48



 Aon UK Limited is authorised and regulated by the Financial Services
 Authority in respect of insurance mediation activities only.

 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.





 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.




  --


 PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL



 For Aon’s standard conditions associated with this e-mail please visit
 http://www.aon.com/uk/en/email

RE: $$Excel-Macros$$ Pivot table

[Manjunath Narayanappa]

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://vbadud.blogspot.in/2008/05/create-pivot-table-using-excel-vba.html
.

Enjoy
Team XLS

On Tue, Mar 26, 2013 at 5:51 PM, Manjunath Narayanappa 
manjunath.narayana...@aon.co.ukmailto:manjunath.narayana...@aon.co.uk wrote:
But every day i need to run report  update in fresh spreadsheet

From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com 
[mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On 
Behalf Of xlstime
Sent: 26 March 2013 12:07
To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com

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

Hi Maniunath,

if headers are fixed then i think no need for create pivot-table on daily.. 
just refresh pivot daily ...

.

Enjoy
Team XLS

On Tue, Mar 26, 2013 at 3:42 PM, Manjunath Narayanappa 
manjunath.narayana...@aon.co.ukmailto:manjunath.narayana...@aon.co.uk wrote:
Dear Experts

Everyday I need to create pivot table to find the Age of each case( Query , 
WIP, untouched, draft) Is there any way to assign macro to the report

Thanks
Manjunath

From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com 
[mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On 
Behalf Of xlstime
Sent: 25 March 2013 17:24
To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com
Cc: gawlianil8...@gmail.commailto: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...@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 sheet1  extract same to sheet 2(Pivot table) So I can find the age of the 
case .
In sheet 2 from pivot table can we pulling same information to DSR(which is 
highlight in Pink)

Thanks
Manjunath



PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL



For Aon's standard conditions associated with this e-mail please visit 
http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp

Aon UK Limited

Registered Office: 8 Devonshire Square, London EC2M 4PL

Registered in London No. 210725 . VAT Registration No. 480 8401 48



Aon UK Limited is authorised and regulated by the Financial Services Authority 
in respect of insurance mediation activities only.
--
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
excel-macros+unsubscr...@googlegroups.commailto:excel-macros%2bunsubscr...@googlegroups.com.
To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.



--
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups MS 
EXCEL

Re: $$Excel-Macros$$ Pivot table

[xlstime]

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 sheet1  extract same to sheet 2(Pivot table) So I can find
 the age of the case .

 In sheet 2 from pivot table can we pulling same information to DSR(which
 is highlight in Pink)



 Thanks

 Manjunath

 --

 PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL



 For Aon’s standard conditions associated with this e-mail please visit
 http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp

 Aon UK Limited

 Registered Office: 8 Devonshire Square, London EC2M 4PL

 Registered in London No. 210725 . VAT Registration No. 480 8401 48



 Aon UK Limited is authorised and regulated by the Financial Services
 Authority in respect of insurance mediation activities only.

 --
 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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
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 thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

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 thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






-- 
Thanks  Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

-- 
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 Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




Copy of Pivot table.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Pivot table

[Anoop K Sharma]

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 Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




Copy of Pivot table.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

[Sheyn Lee]

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 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
 '=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 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 @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






 --
 Regards,
 Anoop

  --
 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, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.




  --
 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, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






 --
 Regards,
 Anoop

  --
 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 Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding 

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

[Anoop K Sharma]

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
 '=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 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 @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






 --
 Regards,
 Anoop

  --
 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, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.




  --
 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, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






-- 
Regards,
Anoop

-- 
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 Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 

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

[Sheyn Lee]

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 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 @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






 --
 Regards,
 Anoop

  --
 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, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.




-- 
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, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

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

[Anoop K Sharma]

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 @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.






-- 
Regards,
Anoop

-- 
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, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

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

[Sheyn Lee]

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, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.




Pivot.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

[Mangesh Vimay]

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 will help to you.

 --
 With Regards,
 Noorain Ansari
 http://
 http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
 http://
 http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com



 On Fri, Aug 31, 2012 at 6:20 PM, KAUSHIK SAVLA
 savla.kaus...@gmail.comwrote:

 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 extract the details of each supplier in different tab
 so as to create an invoice for the individual supplier showing them the
 transactions during the amount. The extracted data should automatically
 extract data from pivot for as many supplier available. In the attached
 file as instance there are 4 suppliers namely A,B,C,D.*
 *4. The extracted data should automatically rename the worksheet tab
 containing the name of supplier.*
 *
 *
 *Looking forward for your prompt response.*
 *
 *
 *Regards,*
 *Kaushik Savla*

  --
 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, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.




 --
 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, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.





-- 
With regards,

*MaNgEsH*

-- 
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, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

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

[Mangesh Vimay]

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 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 will help to you.

 --
 With Regards,
 Noorain Ansari
 http://
 http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
 http://
 http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com



 On Fri, Aug 31, 2012 at 6:20 PM, KAUSHIK SAVLA
 savla.kaus...@gmail.comwrote:

 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 extract the details of each supplier in different tab
 so as to create an invoice for the individual supplier showing them the
 transactions during the amount. The extracted data should automatically
 extract data from pivot for as many supplier available. In the attached
 file as instance there are 4 suppliers namely A,B,C,D.*
 *4. The extracted data should automatically rename the worksheet tab
 containing the name of supplier.*
 *
 *
 *Looking forward for your prompt response.*
 *
 *
 *Regards,*
 *Kaushik Savla*

  --
 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, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.




 --
 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, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE  : Don't ever post personal or confidential data in a workbook.
 Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.





 --
 With regards,

 *MaNgEsH*



-- 
With regards,

*MaNgEsH*

-- 
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, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are 

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

[KAUSHIK SAVLA]

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 extract the details of each supplier in different tab so
as to create an invoice for the individual supplier showing them the
transactions during the amount. The extracted data should automatically
extract data from pivot for as many supplier available. In the attached
file as instance there are 4 suppliers namely A,B,C,D.*
*4. The extracted data should automatically rename the worksheet tab
containing the name of supplier.*
*
*
*Looking forward for your prompt response.*
*
*
*Regards,*
*Kaushik Savla*

-- 
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, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Sirish.xlsm
Description: Binary data

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

[(%Allmydreams%)]

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.

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Pivot Table and Chart.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

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

[ashish koul]

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, 2012 at 9:07 PM, (%Allmydreams%) 
yogananda.mutha...@gmail.com wrote:

 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.

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com






-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Pivot Table and Chart.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Pivot table

[Sara Lee]

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

is therer any way to correct that last column formula in the pivot so that
it updates itself when data is refresehed. thanks

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Book4.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Pivot table

[Maries]

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

 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

 is therer any way to correct that last column formula in the pivot so that
 it updates itself when data is refresehed. thanks

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Pivot Calculation.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Pivot table

[Sara Lee]

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, Maries talk2mar...@gmail.com wrote:

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

 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

 is therer any way to correct that last column formula in the pivot so
 that it updates itself when data is refresehed. thanks

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Pivot table

[Maries]

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--- 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, Maries talk2mar...@gmail.com wrote:

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

 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

 is therer any way to correct that last column formula in the pivot so
 that it updates itself when data is refresehed. thanks

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Pivot Calculation.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Pivot table

[Sara Lee]

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,

 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--- 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, Maries talk2mar...@gmail.com wrote:

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

 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

 is therer any way to correct that last column formula in the pivot so
 that it updates itself when data is refresehed. thanks

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 

Re: $$Excel-Macros$$ Pivot table

[Maries]

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 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--- 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, Maries talk2mar...@gmail.com wrote:

 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.comwrote:

 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

 is therer any way to correct that last column formula in the pivot so
 that it updates itself when data is refresehed. thanks

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum
 in signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


 --
 FORUM RULES (986+ members already BANNED for 

$$Excel-Macros$$ Pivot table

[Krishnaraddi]

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 already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Pivot_table.xls
Description: MS-Word document

Re: $$Excel-Macros$$ Pivot table

[NOORAIN ANSARI]

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
 Macros.

 Thanks in advance.

 Krish


 Dear *excel-macros!* Get Yourself a cool, short *@in.com* Email ID 
 now!http://www3.in.com/sso/commonregister.php?ref=INutm_source=inviteutm_medium=outgoing

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Thanks  regards,
Noorain Ansari
 ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Pivot Table

[Shaik Waheed]

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 http://twitter.com/#%21/karan1237
 https://plus.google.com/43524614789164919/posts


 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Pivot Table

[Venkat CV]

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, Shaik Waheed waheedb...@gmail.com wrote:

 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 http://twitter.com/#%21/karan1237
 https://plus.google.com/43524614789164919/posts


 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Maries]

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,

MARIES.


On Wed, Feb 15, 2012 at 7:18 AM, anandydr anand...@gmail.com wrote:

 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 your spreadsheet.

 Warm Regards,
 Anand Kumar

 On Feb 15, 6:15 am, Awal malaw...@gmail.com wrote:
  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 noorain.ans...@gmail.com wrote:
 
 
 
 
 
 
 
   Dear Awal,
 
   Please use it
 
   Press CTRL F3 or go to Edit Insert Name Define
 
   Name your range – e.g. pivot_table_data1
 
   In the refers to section type or copy and paste this formulas
 
   =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1))
 
   or
 
=Sheet1!$A$1:INDEX(Sheet1!$A:$F,COUNTA(Sheet1!$A:$A),6)
 
   [image: clip_image002] 
 http://www.spyjournal.biz/files/clip_image002_0.jpg
 
   Assuming that your data starts in cell A1 of Sheet1. Edit accordingly
   before pasting in
 
   What this formula does is creates an array that starts at cell a1 goes
 zero
   cells down and zero cells right, and is x cells deep and y cells wide.
 x =
   the count of all non blank cells in column A and y the count of all non
   blank cells in row 1. Assumes that column A and row 1 are contiguous
 data
   blocks the same length and width as the whole data set. If not use
 columns
   and rows that are.
 
   Now in your pivot table right click and go to Pivot Table Wizard
 
   [image: clip_image004] 
 http://www.spyjournal.biz/files/clip_image004_1.jpg
 
   Hit Back and go to the range selection
 
   [image: clip_image006] 
 http://www.spyjournal.biz/files/clip_image006_1.jpg
 
   Type = and the range name = e.g. =pivot_table_data1
 
   In my case my range name was called test.
 
   Hit Finish and it is done.
 
   Now whenever you paste more data into the data sheet the pivot table
 just
   needs to be refreshed to pick it up
 
   Click anywhere on the pivot table and click the exclamation mark in the
   toolbar.
 
   The instructions above assume you are using office 2003. In office
 2007 the
   Name Manager is a little more confusing, but can be accessed with the
 same
   keyboard shortcut and you will need to create a new range name and
 then use
   the same formula listed above.
 
   --
   Thanks  regards,
   Noorain Ansari
*http://noorainansari.com/*
   *http://excelmacroworld.blogspot.com/*
 http://excelmacroworld.blogspot.com/
 
   On Tue, Feb 14, 2012 at 6:49 AM, Awal malaw...@gmail.com wrote:
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 ends)
 
Thank you.
 
--
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like
 Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice
will not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5)  Cross-promotion of, or links to, forums competitive to this
 forum in
signatures are prohibited.
 
NOTE  : Don't ever post personal or confidential data in a workbook.
 Forum
owners and members are not responsible for any loss.
 
   
 ---
 ---
To post to this group, send email to excel-macros@googlegroups.com

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures 

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

[Awal]

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 noorain.ans...@gmail.com wrote:
 Dear Awal,

 Please use it

 Press CTRL F3 or go to Edit Insert Name Define

 Name your range – e.g. pivot_table_data1

 In the refers to section type or copy and paste this formulas

 =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1))

 or

  =Sheet1!$A$1:INDEX(Sheet1!$A:$F,COUNTA(Sheet1!$A:$A),6)

 [image: clip_image002] http://www.spyjournal.biz/files/clip_image002_0.jpg

 Assuming that your data starts in cell A1 of Sheet1. Edit accordingly
 before pasting in

 What this formula does is creates an array that starts at cell a1 goes zero
 cells down and zero cells right, and is x cells deep and y cells wide. x =
 the count of all non blank cells in column A and y the count of all non
 blank cells in row 1. Assumes that column A and row 1 are contiguous data
 blocks the same length and width as the whole data set. If not use columns
 and rows that are.

 Now in your pivot table right click and go to Pivot Table Wizard

 [image: clip_image004] http://www.spyjournal.biz/files/clip_image004_1.jpg

 Hit Back and go to the range selection

 [image: clip_image006] http://www.spyjournal.biz/files/clip_image006_1.jpg

 Type = and the range name = e.g. =pivot_table_data1

 In my case my range name was called test.

 Hit Finish and it is done.

 Now whenever you paste more data into the data sheet the pivot table just
 needs to be refreshed to pick it up

 Click anywhere on the pivot table and click the exclamation mark in the
 toolbar.

 The instructions above assume you are using office 2003. In office 2007 the
 Name Manager is a little more confusing, but can be accessed with the same
 keyboard shortcut and you will need to create a new range name and then use
 the same formula listed above.

 --
 Thanks  regards,
 Noorain Ansari
  *http://noorainansari.com/*
 *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/







 On Tue, Feb 14, 2012 at 6:49 AM, Awal malaw...@gmail.com wrote:
  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 ends)

  Thank you.

  --
  FORUM RULES (986+ members already BANNED for violation)

  1) Use concise, accurate thread titles. Poor thread titles, like Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
  will not get quick attention or may not be answered.

  2) Don't post a question in the thread of another member.

  3) Don't post questions regarding breaking or bypassing any security
  measure.

  4) Acknowledge the responses you receive, good or bad.

  5)  Cross-promotion of, or links to, forums competitive to this forum in
  signatures are prohibited.

  NOTE  : Don't ever post personal or confidential data in a workbook. Forum
  owners and members are not responsible for any loss.

  --- 
  ---
  To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[anandydr]

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 your spreadsheet.

Warm Regards,
Anand Kumar

On Feb 15, 6:15 am, Awal malaw...@gmail.com wrote:
 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 noorain.ans...@gmail.com wrote:







  Dear Awal,

  Please use it

  Press CTRL F3 or go to Edit Insert Name Define

  Name your range – e.g. pivot_table_data1

  In the refers to section type or copy and paste this formulas

  =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1))

  or

   =Sheet1!$A$1:INDEX(Sheet1!$A:$F,COUNTA(Sheet1!$A:$A),6)

  [image: clip_image002] http://www.spyjournal.biz/files/clip_image002_0.jpg

  Assuming that your data starts in cell A1 of Sheet1. Edit accordingly
  before pasting in

  What this formula does is creates an array that starts at cell a1 goes zero
  cells down and zero cells right, and is x cells deep and y cells wide. x =
  the count of all non blank cells in column A and y the count of all non
  blank cells in row 1. Assumes that column A and row 1 are contiguous data
  blocks the same length and width as the whole data set. If not use columns
  and rows that are.

  Now in your pivot table right click and go to Pivot Table Wizard

  [image: clip_image004] http://www.spyjournal.biz/files/clip_image004_1.jpg

  Hit Back and go to the range selection

  [image: clip_image006] http://www.spyjournal.biz/files/clip_image006_1.jpg

  Type = and the range name = e.g. =pivot_table_data1

  In my case my range name was called test.

  Hit Finish and it is done.

  Now whenever you paste more data into the data sheet the pivot table just
  needs to be refreshed to pick it up

  Click anywhere on the pivot table and click the exclamation mark in the
  toolbar.

  The instructions above assume you are using office 2003. In office 2007 the
  Name Manager is a little more confusing, but can be accessed with the same
  keyboard shortcut and you will need to create a new range name and then use
  the same formula listed above.

  --
  Thanks  regards,
  Noorain Ansari
   *http://noorainansari.com/*
  *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/

  On Tue, Feb 14, 2012 at 6:49 AM, Awal malaw...@gmail.com wrote:
   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 ends)

   Thank you.

   --
   FORUM RULES (986+ members already BANNED for violation)

   1) Use concise, accurate thread titles. Poor thread titles, like Please
   Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
   will not get quick attention or may not be answered.

   2) Don't post a question in the thread of another member.

   3) Don't post questions regarding breaking or bypassing any security
   measure.

   4) Acknowledge the responses you receive, good or bad.

   5)  Cross-promotion of, or links to, forums competitive to this forum in
   signatures are prohibited.

   NOTE  : Don't ever post personal or confidential data in a workbook. Forum
   owners and members are not responsible for any loss.

   ---
---
   To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Awal]

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 ends)

Thank you.

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[B Sharma]

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 it will look like
this

Month  -  Op. Bal. - Purchase - Consumption - Cl.Bal.

I need to import the data from two separate sheets here and show
report in one report.

Thanks  Regards,
BS

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Shaik Waheed]

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 date,consumption date,  inv. no. party name., item, qty. ,
 values, etc.



 Now I need to create a Pivot table, in which it will look like
 this

 Month  -  Op. Bal. - Purchase - Consumption - Cl.Bal.

 I need to import the data from two separate sheets here and show
 report in one report.

 Thanks  Regards,
 BS

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[NOORAIN ANSARI]

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 like.
 purchase date,consumption date,  inv. no. party name., item, qty. ,
 values, etc.



 Now I need to create a Pivot table, in which it will look like
 this

 Month  -  Op. Bal. - Purchase - Consumption - Cl.Bal.

 I need to import the data from two separate sheets here and show
 report in one report.

 Thanks  Regards,
 BS

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Thanks  regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Excel2003_Style_Menu.xlam
Description: Binary data

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

[Mahreen Ellahi]

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 PM, Mahreen Ellahi mahreen.acc...@gmail.com
  wrote:

 Guys

 I have a range of data of which I want to plot a pivot table. My problem
 is that I have different expiry days but I want to club or group into
 certain buckets like 0 days,1- 30 days, 31-60 days etc. I dont want to
 take unexpired negative values in my pivot table. HELP NEEDED IN ATTACHED
 FILE. SAMPLE FORMAT ATTACHED BUT NOT AS A PIVOT TABLE.

   S # REGION BRANCH SEGMENT CUSTOMER NAME DATE OF APPROVAL ORIGINAL
 APPROVING AUTHORITY TOTAL FUNDED  NON-FUNDED LIMIT (IN MILLION) DATE OF
 INTERIM REVIEW ANNUAL REVIEW DATE VALIDITY / EXPIRY Days Expired   1 SOUTH
 I KHI CORPORATEABC 07-Oct-2010 CC 50.000   31-Mar-2012
 31-Mar-2012  (90)  2 SOUTH I KHI COMMERCIAL  DEF
 23-Dec-2010 CC 300.000   31-Dec-2011 31-Dec-2011 1  3 SOUTH
 I KHI COMMERCIAL  SDS 02-Feb-2011 CC 682.940   29-Feb-2012 28-Feb-11
 307  4 SOUTH I KHI CORPORATE FDFG  01-Nov-2010 CC 300.000
 31-Mar-2012 31-Mar-2012  (90)  5 SOUTH I KHI CORPORATE
   DFG 02-May-2011 CC 1,200.000   31-Mar-2012 31-Mar-2011 276
 6 SOUTH I KHI SME FDFG 25-Aug-2010 CC 375.000   31-Mar-2012 31-Mar-2012
 (90)  7 SOUTH I KHI SME SDF 03-May-2011 CC 600.000   31-Mar-2012
 31-Mar-2010 641  8 SOUTH I KHI SME SDF 27-Jun-2011 CC 620.000
   30-Apr-2012 30-Apr-2012(120)  9 SOUTH I KHI CORPORATE DSF
 22-Mar-2011 CC 210.000   30-Apr-2012 30-Sep-2011   93  10 SOUTH
 I KHI CORPORATE SDF 23-May-2011 CC 471.000   30-Apr-2012 30-Apr-2012
 (120)  11 SOUTH I KHI COMMERCIAL SDF 10-May-2011 CC 800.000   30-Apr-2012
 30-Apr-2012(120)  12 SOUTH I KHI CORPORATE SDF 23-May-2011 CC 
 1,300.000
   31-Mar-2012 31-Mar-2012  (90)  13 SOUTH I KHI CORPORATE
 FDFG 13-Jul-2011 CC 1,300.000   31-Aug-2012 31-Aug-2011 123
 14 SOUTH I KHI SME DFG 24-Jun-2010 CC 1,200.000   30-Sep-2011 30-Sep-2011
 93  15 SOUTH I KHI CORPORATE DFG 18-Mar-2011 CC 400.000   31-Dec-2011
 31-Dec-2011 1  16 SOUTH I KHI SME FDFGSD 02-Nov-2011 CC 
 300.000
   31-Dec-2012 31-Jan-2009  1,065  17 SOUTH I KHI CORPORATE SDF
 28-Mar-2011 CC 400.000   31-Mar-2012 31-Mar-2012  (90)  18 SOUTH
 I KHI COMMERCIAL SDF 23-Nov-2011 CC 900.000   31-Dec-2012 31-Dec-2012
 (365)  19 SOUTH I KHI CORPORATE SDF 17-Jun-2011 CC 2,000.000
 30-Apr-2012 30-May-2011 216  20 SOUTH I KHI COMMERCIAL SDF
 28-Mar-2011 CC 1,700.000   30-Apr-2012 30-Apr-2012(120)

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or 

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

[PrIyAnKa]

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 and see the yellow highlighted row ,i have
 did the same w/o pivot



 On Thu, Jan 19, 2012 at 11:12 PM, Mahreen Ellahi 
 mahreen.acc...@gmail.com wrote:

 Guys

 I have a range of data of which I want to plot a pivot table. My problem
 is that I have different expiry days but I want to club or group into
 certain buckets like 0 days,1- 30 days, 31-60 days etc. I dont want to
 take unexpired negative values in my pivot table. HELP NEEDED IN ATTACHED
 FILE. SAMPLE FORMAT ATTACHED BUT NOT AS A PIVOT TABLE.

   S # REGION BRANCH SEGMENT CUSTOMER NAME DATE OF APPROVAL ORIGINAL
 APPROVING AUTHORITY TOTAL FUNDED  NON-FUNDED LIMIT (IN MILLION) DATE
 OF INTERIM REVIEW ANNUAL REVIEW DATE VALIDITY / EXPIRY Days Expired   1 
 SOUTH
 I KHI CORPORATEABC 07-Oct-2010 CC 50.000   31-Mar-2012
 31-Mar-2012  (90)  2 SOUTH I KHI COMMERCIAL  DEF
 23-Dec-2010 CC 300.000   31-Dec-2011 31-Dec-2011 1  3 SOUTH
 I KHI COMMERCIAL  SDS 02-Feb-2011 CC 682.940   29-Feb-2012 28-Feb-11
 307  4 SOUTH I KHI CORPORATE FDFG  01-Nov-2010 CC 300.000
 31-Mar-2012 31-Mar-2012  (90)  5 SOUTH I KHI CORPORATE
 DFG 02-May-2011 CC 1,200.000   31-Mar-2012 31-Mar-2011
 276  6 SOUTH I KHI SME FDFG 25-Aug-2010 CC 375.000   31-Mar-2012
 31-Mar-2012  (90)  7 SOUTH I KHI SME SDF 03-May-2011 CC 600.000
   31-Mar-2012 31-Mar-2010 641  8 SOUTH I KHI SME SDF
 27-Jun-2011 CC 620.000   30-Apr-2012 30-Apr-2012(120)  9 SOUTH
 I KHI CORPORATE DSF 22-Mar-2011 CC 210.000   30-Apr-2012 30-Sep-2011
 93  10 SOUTH I KHI CORPORATE SDF 23-May-2011 CC 471.000   30-Apr-2012
 30-Apr-2012(120)  11 SOUTH I KHI COMMERCIAL SDF 10-May-2011
 CC 800.000   30-Apr-2012 30-Apr-2012(120)  12 SOUTH I KHI
 CORPORATE SDF 23-May-2011 CC 1,300.000   31-Mar-2012 31-Mar-2012
 (90)  13 SOUTH I KHI CORPORATE FDFG 13-Jul-2011 CC 1,300.000
 31-Aug-2012 31-Aug-2011 123  14 SOUTH I KHI SME DFG
 24-Jun-2010 CC 1,200.000   30-Sep-2011 30-Sep-2011   93  15 
 SOUTH
 I KHI CORPORATE DFG 18-Mar-2011 CC 400.000   31-Dec-2011 31-Dec-2011
 1  16 SOUTH I KHI SME FDFGSD 02-Nov-2011 CC 300.000   31-Dec-2012
 31-Jan-2009  1,065  17 SOUTH I KHI CORPORATE SDF 28-Mar-2011 CC 
 400.000
   31-Mar-2012 31-Mar-2012  (90)  18 SOUTH I KHI COMMERCIAL
 SDF 23-Nov-2011 CC 900.000   31-Dec-2012 31-Dec-2012(365)
 19 SOUTH I KHI CORPORATE SDF 17-Jun-2011 CC 2,000.000   30-Apr-2012
 30-May-2011 216  20 SOUTH I KHI COMMERCIAL SDF 28-Mar-2011
 CC 1,700.000   30-Apr-2012 30-Apr-2012(120)

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions 

$$Excel-Macros$$ Pivot Table data extract

[Anil Bhange]

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 to Range

Is there any shortcut where I don't get these details in Table format and will 
get in the normal data details.


Anil Bhange

Assistant Manager
Financial Reporting  Compliance,

TATA Communications Ltd.
VSB, Fort,  Mumbai - 400 001,
India



' Desk : + 91 22 6659 2320
| IP Phone : 51 2320 | Mobile :+ 91 90290 32123

anil.bha...@tatacommunications.commailto:anil.bha...@tatacommunications.com



--

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[Shaik Waheed]

 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 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??
 Plz 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Pivot Table data extract

[Anil Bhange]

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 to Range

Is there any shortcut where I don't get these details in Table format and will 
get in the normal data details.


Anil Bhange

Assistant Manager
Financial Reporting  Compliance,

TATA Communications Ltd.
VSB, Fort,  Mumbai - 400 001,
India



' Desk : + 91 22 6659 2320
| IP Phone : 51 2320 | Mobile :+ 91 90290 32123

anil.bha...@tatacommunications.commailto:anil.bha...@tatacommunications.com



-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[Shaik Waheed]

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 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 to Range”

 ** **

 Is there any shortcut where I don’t get these details in Table format and
 will get in the normal data details.

 ** **

 ** **

 *Anil Bhange*

 *Assistant Manager*
 Financial Reporting  Compliance,

 TATA Communications Ltd.
 VSB, Fort,  Mumbai – 400 001,
 India

 ** **

 ' Desk : + 91 22 6659 2320
 | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 

 anil.bha...@tatacommunications.com

 ** **

 ** **

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[Anil Bhange]

Sorry.. just to reframe the question...

I wanted all the details but not in Table format, because there I again need 
to convert the table to Range

I want the information in normal format without any formatting.

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: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 and then Uncheck- Enable Show Details.
On Fri, Sep 2, 2011 at 4:44 PM, Anil Bhange 
anil.bha...@tatacommunications.commailto:anil.bha...@tatacommunications.com 
wrote:
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 to Range

Is there any shortcut where I don't get these details in Table format and will 
get in the normal data details.


Anil Bhange

Assistant Manager
Financial Reporting  Compliance,

TATA Communications Ltd.
VSB, Fort,  Mumbai - 400 001,
India



' Desk : + 91 22 6659 2320tel:%2B%2091%2022%206659%202320
| IP Phone : 51 2320 | Mobile :+ 91 90290 32123tel:%2B%2091%2090290%2032123

anil.bha...@tatacommunications.commailto:anil.bha...@tatacommunications.com



--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/
4. Learn VBA Macros at 
http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/

To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.commailto:excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[Prabhu]

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

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[Mahesh parab]

Hi Anil

copy below code in thisworkbook model

Private Sub Workbook_NewSheet(ByVal Sh As Object)
 Dim sht As Worksheet
Dim oLo As ListObject
Set sht = ActiveSheet
For Each oLo In sht.ListObjects
sht.ListObjects(oLo.Name).TableStyle = 
Next
End Sub


Thanks
Mahesh

On Fri, Sep 2, 2011 at 6:02 PM, Shaik Waheed waheedb...@gmail.com wrote:

 Dear Anil.

 When u get the details in Table Format, Goto 'Design Tab-Table
 Styles--Select Clear.dats it.

 U dont have any other easier option than this

 Regards,
 Waheed
 On Fri, Sep 2, 2011 at 5:00 PM, Anil Bhange 
 anil.bha...@tatacommunications.com wrote:

  Sorry.. just to reframe the question…

 ** **

 I wanted all the details but not in “Table” format, because there I again
 need to convert the table to Range

 ** **

 I want the information in normal format without any formatting.

 ** **

 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: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 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 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 to Range”
 

  

 Is there any shortcut where I don’t get these details in Table format and
 will get in the normal data details.

  

  

 *Anil Bhange*

 *Assistant Manager*
 Financial Reporting  Compliance,

 TATA Communications Ltd.
 VSB, Fort,  Mumbai – 400 001,
 India

  

 ' Desk : + 91 22 6659 2320
 | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 

 anil.bha...@tatacommunications.com

  

  

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

 ** **

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


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

[Shaik Waheed]

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 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[Shaik Waheed]

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 Excel. Thank you!

 On Thu, Sep 1, 2011 at 5:44 PM, Shaik Waheed waheedb...@gmail.com wrote:

 Hi John,

 PFA, i have deleted some rows bcoz the file size was getting huge.

 What u need to do is take this as example and do it in ur original
 file, in sheet 2 u need to drag down the formulas till the end.

 Hope it hels u

 Regards,
 Waheed

 On Thu, Sep 1, 2011 at 1:59 PM, John Alliage Tinio Morales
 alliage.mora...@gmail.com wrote:
  I attach my raw file.
 
  GEOCODE contains the geographic code
  Other sheets contain the geographical areas without the codes
 
  On Thu, Sep 1, 2011 at 4:17 PM, Shaik Waheed waheedb...@gmail.com
  wrote:
 
  Can u plz mail a sample file.
 
  On Thu, Sep 1, 2011 at 1:08 PM, John Alliage Tinio Morales
  alliage.mora...@gmail.com wrote:
   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 IS NUMERICAL IN NATURE.
  
   Now, I have also another sheet which lists the same geographical data
   (divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN,
   and
   BARANGAY/STREET). The geographic areas included in this sheet are
   recipients
   of one government program. But this sheet does not contain the UNIQUE
   GEOGRAPHICAL CODE.
  
   What I would like to do is to match the geographical data found in
   two
   sheets, and if they match, copy/replicate/add the UNIQUE GEOGRAPHICAL
   CODE
   found in sheet to the other sheet that does not contain the code.
  
   I would like to include the geographical code, so that it would
   become
   the
   primary key when I create a database in MS Access.
  
   This is the example
  
   SHEET 1
   A B C D E
   0019 REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET
  
   *Column A contains the UNIQUE GEOGRAPHICAL CODE
  
   SHEET 2
   A B C D
   REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET
  
   *Sheet 2 contains only 20k entries of geographical areas while Sheet
   1
   contains about 40k entries. Only half of the geographical areas are
   included
   in the government program
  
   Can you help me?
  
  
   On Thu, Sep 1, 2011 at 3:11 PM, Shaik Waheed waheedb...@gmail.com
   wrote:
  
   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 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 LinkedIN group @
http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
   
To post to this group, send email to excel-macros@googlegroups.com
   

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
   
  
   --
  
  
  
   --
   Some important links for excel users:
   1. Follow us on TWITTER for tips tricks and links :
   http://twitter.com/exceldailytip
   2. Join our LinkedIN group @
   http://www.linkedin.com/groups?gid=1871310
   3. Excel tutorials at http://www.excel-macros.blogspot.com
   4. Learn VBA Macros at http://www.quickvba.blogspot.com
   5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
  
   To post to this group, send email to excel-macros@googlegroups.com
  
   
   Like our page on facebook , Just follow below link
   http://www.facebook.com/discussexcel
  
  
  
   --
   John Alliage Tinio Morales
   Researcher
   GMA News and Public Affairs
   Mobile: 0915.846.8473
   Tel: (02) 982. loc 1338
   Fax: (02) 982. loc 1340
  
  
  
   DISCLAIMER:
   This Message may contain confidential information intended only for
   the
   use
   of the addressee named above. If you are not the intended recipient
   of
   this
   message you are hereby notified that any use, dissemination,
   distribution or
   reproduction of this message is prohibited. If you received this
   message
   

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

[John Alliage Tinio Morales]

*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 IS NUMERICAL IN NATURE.

Now, I have also another sheet which lists the same geographical data
(divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN, and
BARANGAY/STREET). The geographic areas included in this sheet are recipients
of one government program. But this sheet does not contain the UNIQUE
GEOGRAPHICAL CODE.

What I would like to do is to match the geographical data found in two
sheets, and if they match, copy/replicate/add the UNIQUE GEOGRAPHICAL CODE
found in sheet to the other sheet that does not contain the code.

I would like to include the geographical code, so that it would become the
primary key when I create a database in MS Access.

This is the example

SHEET 1
A B C D E
0019 REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET

*Column A contains the UNIQUE GEOGRAPHICAL CODE

SHEET 2
A B C D
REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET

*Sheet 2 contains only 20k entries of geographical areas while Sheet 1
contains about 40k entries. Only half of the geographical areas are included
in the government program

Can you help me?


On Thu, Sep 1, 2011 at 3:11 PM, Shaik Waheed waheedb...@gmail.com wrote:

 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 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
  To post to this group, send email to excel-macros@googlegroups.com
 
  
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel
 

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*John Alliage Tinio Morales*
*Researcher**
GMA News and Public Affairs*
Mobile: 0915.846.8473
Tel: (02) 982. loc 1338
Fax: (02) 982. loc 1340



DISCLAIMER:
This Message may contain confidential information intended only for the use
of the addressee named above. If you are not the intended recipient of this
message you are hereby notified that any use, dissemination, distribution or
reproduction of this message is prohibited. If you received this message in
error please notify your Mail Administrator and delete this message
immediately. Any views expressed in this message are those of the individual
sender and may not necessarily reflect the views of GMA Network, Inc.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[Shankar Bheema]

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 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 Excel. Thank you!
 
  On Thu, Sep 1, 2011 at 5:44 PM, Shaik Waheed waheedb...@gmail.com
 wrote:
 
  Hi John,
 
  PFA, i have deleted some rows bcoz the file size was getting huge.
 
  What u need to do is take this as example and do it in ur original
  file, in sheet 2 u need to drag down the formulas till the end.
 
  Hope it hels u
 
  Regards,
  Waheed
 
  On Thu, Sep 1, 2011 at 1:59 PM, John Alliage Tinio Morales
  alliage.mora...@gmail.com wrote:
   I attach my raw file.
  
   GEOCODE contains the geographic code
   Other sheets contain the geographical areas without the codes
  
   On Thu, Sep 1, 2011 at 4:17 PM, Shaik Waheed waheedb...@gmail.com
   wrote:
  
   Can u plz mail a sample file.
  
   On Thu, Sep 1, 2011 at 1:08 PM, John Alliage Tinio Morales
   alliage.mora...@gmail.com wrote:
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 IS NUMERICAL IN NATURE.
   
Now, I have also another sheet which lists the same geographical
 data
(divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN,
and
BARANGAY/STREET). The geographic areas included in this sheet are
recipients
of one government program. But this sheet does not contain the
 UNIQUE
GEOGRAPHICAL CODE.
   
What I would like to do is to match the geographical data found in
two
sheets, and if they match, copy/replicate/add the UNIQUE
 GEOGRAPHICAL
CODE
found in sheet to the other sheet that does not contain the code.
   
I would like to include the geographical code, so that it would
become
the
primary key when I create a database in MS Access.
   
This is the example
   
SHEET 1
A B C D E
0019 REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET
   
*Column A contains the UNIQUE GEOGRAPHICAL CODE
   
SHEET 2
A B C D
REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET
   
*Sheet 2 contains only 20k entries of geographical areas while
 Sheet
1
contains about 40k entries. Only half of the geographical areas are
included
in the government program
   
Can you help me?
   
   
On Thu, Sep 1, 2011 at 3:11 PM, Shaik Waheed waheedb...@gmail.com
 
wrote:
   
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 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 LinkedIN group @
 http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to
 excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

   
--
   
   
   
   
 --
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
   
To post to this group, send email to
 excel-macros@googlegroups.com
   

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
   
   
   
--
John Alliage Tinio Morales
Researcher
GMA News and Public Affairs
Mobile: 0915.846.8473
Tel: (02) 982. loc 1338
Fax: (02) 982. loc 1340
   
   
   
DISCLAIMER:
   

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

[Shaik Waheed]

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:
 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 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 Excel. Thank you!
 
  On Thu, Sep 1, 2011 at 5:44 PM, Shaik Waheed waheedb...@gmail.com
  wrote:
 
  Hi John,
 
  PFA, i have deleted some rows bcoz the file size was getting huge.
 
  What u need to do is take this as example and do it in ur original
  file, in sheet 2 u need to drag down the formulas till the end.
 
  Hope it hels u
 
  Regards,
  Waheed
 
  On Thu, Sep 1, 2011 at 1:59 PM, John Alliage Tinio Morales
  alliage.mora...@gmail.com wrote:
   I attach my raw file.
  
   GEOCODE contains the geographic code
   Other sheets contain the geographical areas without the codes
  
   On Thu, Sep 1, 2011 at 4:17 PM, Shaik Waheed waheedb...@gmail.com
   wrote:
  
   Can u plz mail a sample file.
  
   On Thu, Sep 1, 2011 at 1:08 PM, John Alliage Tinio Morales
   alliage.mora...@gmail.com wrote:
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 IS NUMERICAL IN NATURE.
   
Now, I have also another sheet which lists the same geographical
data
(divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN,
and
BARANGAY/STREET). The geographic areas included in this sheet are
recipients
of one government program. But this sheet does not contain the
UNIQUE
GEOGRAPHICAL CODE.
   
What I would like to do is to match the geographical data found in
two
sheets, and if they match, copy/replicate/add the UNIQUE
GEOGRAPHICAL
CODE
found in sheet to the other sheet that does not contain the code.
   
I would like to include the geographical code, so that it would
become
the
primary key when I create a database in MS Access.
   
This is the example
   
SHEET 1
A B C D E
0019 REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET
   
*Column A contains the UNIQUE GEOGRAPHICAL CODE
   
SHEET 2
A B C D
REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET
   
*Sheet 2 contains only 20k entries of geographical areas while
Sheet
1
contains about 40k entries. Only half of the geographical areas
are
included
in the government program
   
Can you help me?
   
   
On Thu, Sep 1, 2011 at 3:11 PM, Shaik Waheed
waheedb...@gmail.com
wrote:
   
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 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 LinkedIN group @
 http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to
 excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

   
--
   
   
   
   
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
   
To post to this group, send email to

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

[Prabhu]

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

Plz 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Pivot.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

[Prabhu]

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

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[suryaprasad . bv]

Can you post the pivoted file plz ?

Thanks
Prasad
Sent from BlackBerry® on Airtel

-Original Message-
From: Prabhu prabhugate...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Wed, 31 Aug 2011 12:28:10 
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
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 be in date format)

Plz 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[Venkat CV]

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

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[Prabhu]

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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Pivot.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

[Amit Desai (MERU)]

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




Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[Rajan_Verma]

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

 

 

 

  _  

Disclaimer: This message and its attachments contain confidential
information and may also contain legally privileged information. This
message is intended solely for the named addressee. If you are not the
addressee indicated in this message (or authorized to receive for
addressee), you may not copy or deliver any part of this message or its
attachments to anyone or use any part of this message or its attachments.
Rather, you should permanently delete this message and its attachments (and
all copies) from your system and kindly notify the sender by reply e-mail.
Any content of this message and its attachments that does not relate to the
official business of Meru Cab Company Pvt. Ltd. must be taken not to have
been sent or endorsed by any of them. Email communications are not private
and no warranty is made that e-mail communications are timely, secure or
free from computer virus or other defect.

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[Amit Desai (MERU)]

That's true... but what if I wants to refresh the Pivot table with new data?

Best Regards,
Amit Desai


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




Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[XLS S]

then ..press Alt + D +P +B and select new range ...

On Mon, Aug 29, 2011 at 2:59 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:

  That’s true… but what if I wants to refresh the Pivot table with new
 data?

 ** **

 Best Regards,

 Amit Desai

 ** **

 ** **

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

 ** **

 ** **

 ** **
  --

 Disclaimer: This message and its attachments contain confidential
 information and may also contain legally privileged information. This
 message is intended solely for the named addressee. If you are not the
 addressee indicated in this message (or authorized to receive for
 addressee), you may not copy or deliver any part of this message or its
 attachments to anyone or use any part of this message or its attachments.
 Rather, you should permanently delete this message and its attachments (and
 all copies) from your system and kindly notify the sender by reply e-mail.
 Any content of this message and its attachments that does not relate to the
 official business of Meru Cab Company Pvt. Ltd. must be taken not to have
 been sent or endorsed by any of them. Email communications are not private
 and no warranty is made that e-mail communications are timely, secure or
 free from computer virus or other defect.

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

 --
 Disclaimer: This message and its attachments contain confidential
 information and may also contain legally privileged information. This
 message is intended solely for the named addressee. If you are not the
 addressee indicated in this message (or authorized to receive for
 addressee), you may not copy or deliver any part of this message or its
 attachments to anyone or use any part of this message or its attachments.
 Rather, you should permanently delete this message and its attachments (and
 all copies) from your system and kindly notify the sender by reply e-mail.
 Any content of this message and its attachments that does not relate to the
 official business of Meru Cab Company Pvt. Ltd. must be taken not to have
 been sent or endorsed by any of them. Email communications are not private
 and no warranty is made that e-mail communications are timely, secure or
 free from computer virus or other defect.

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel

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

[Daniel]

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$$ 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#YearCat1Cat2Cat3
123456 2006$5.00   $4.00   $3.00
234567 2006$5.00   $4.00   $3.00
345678 2006$5.00   $4.00   $3.00
987654 2007$3.00   $4.00   $5.00
876543 2007$3.00   $4.00   $5.00
765432 2007$3.00   $4.00   $5.00

I need a pivot table that will sum all values for each category by year,
then tell me what percent of that year's sales belonged to that category.  I
can get a pivot table to show each category by year with total sales like
this:

Values2006   2007
Cat1   $15.00 $9.00
Cat2   $12.00 $12.00
Cat3   $9.00   $15.00

BUT, I really need the percent of each category for that column.  For
instance, 2006 and 2007 both have $36.00 total sales.  So I would want to
know what percent of that $36.00 was for Cat1, Cat2, and Cat3.
Something like this:

Values20062007
Cat1   42% 25%
Cat2   33% 33%
Cat3   25% 42%

Does anybody have any recommendations?  I have tried Show Value As Percent
of Column, but it always shows 100%.  If I Show Value As Percent of Row, it
shows what percentage of the total sales of Cat1 was sold for each year.
i.e. - Cat1 would show 62% for 2006 and 38% for 2007.  Any help would be
GREATLY appreciated!!!  Thank you!

--

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip 2. Join our LinkedIN group @
http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and
Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[§»VIPER«§]

Hi

please find the attachment it may help


-- 
*Great day,*
*viper

*
On Fri, Aug 26, 2011 at 2:13 PM, Daniel dcolarde...@free.fr 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-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 (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#YearCat1Cat2Cat3
 123456 2006$5.00   $4.00   $3.00
 234567 2006$5.00   $4.00   $3.00
 345678 2006$5.00   $4.00   $3.00
 987654 2007$3.00   $4.00   $5.00
 876543 2007$3.00   $4.00   $5.00
 765432 2007$3.00   $4.00   $5.00

 I need a pivot table that will sum all values for each category by year,
 then tell me what percent of that year's sales belonged to that category.
  I
 can get a pivot table to show each category by year with total sales like
 this:

 Values2006   2007
 Cat1   $15.00 $9.00
 Cat2   $12.00 $12.00
 Cat3   $9.00   $15.00

 BUT, I really need the percent of each category for that column.  For
 instance, 2006 and 2007 both have $36.00 total sales.  So I would want to
 know what percent of that $36.00 was for Cat1, Cat2, and Cat3.
 Something like this:

 Values20062007
 Cat1   42% 25%
 Cat2   33% 33%
 Cat3   25% 42%

 Does anybody have any recommendations?  I have tried Show Value As Percent
 of Column, but it always shows 100%.  If I Show Value As Percent of Row, it
 shows what percentage of the total sales of Cat1 was sold for each year.
 i.e. - Cat1 would show 62% for 2006 and 38% for 2007.  Any help would be
 GREATLY appreciated!!!  Thank you!

 --

 
 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip 2. Join our LinkedIN group @
 http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and
 Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


sample.xls
Description: MS-Excel spreadsheet

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

[Robert Jacobs]

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 my example.  But I
did keep your example in my resources for 'just in case' future
spreadsheets.

Daniel - I had found that page a while ago.  As I mentioned in my
post, it wasn't calculating the percent of the column that I wanted -
it always gave me 100%.  Thanks for the reply though.

Viper - It took me a little digging (because your sample was EXACTLY
what I needed) before I figured out how you accomplished what you
accomplished.  I did, however, figure it out, and it your methods work
perfectly for what I needed.  5000 points to you, and thank you very
much for your help.

All of your suggestions are appreciated.  Thank you for serving us
little guys.  You're awesome!

On Aug 26, 6:31 am, §»VIPER«§ viper@gmail.com wrote:
 Hi

 please find the attachment it may help

 --
 *Great day,*
 *viper

 *







 On Fri, Aug 26, 2011 at 2:13 PM, Daniel dcolarde...@free.fr 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-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 (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        Cat1        Cat2        Cat3
  123456         2006        $5.00       $4.00       $3.00
  234567         2006        $5.00       $4.00       $3.00
  345678         2006        $5.00       $4.00       $3.00
  987654         2007        $3.00       $4.00       $5.00
  876543         2007        $3.00       $4.00       $5.00
  765432         2007        $3.00       $4.00       $5.00

  I need a pivot table that will sum all values for each category by year,
  then tell me what percent of that year's sales belonged to that category.
   I
  can get a pivot table to show each category by year with total sales like
  this:

  Values        2006       2007
  Cat1           $15.00     $9.00
  Cat2           $12.00     $12.00
  Cat3           $9.00       $15.00

  BUT, I really need the percent of each category for that column.  For
  instance, 2006 and 2007 both have $36.00 total sales.  So I would want to
  know what percent of that $36.00 was for Cat1, Cat2, and Cat3.
  Something like this:

  Values        2006        2007
  Cat1           42%         25%
  Cat2           33%         33%
  Cat3           25%         42%

  Does anybody have any recommendations?  I have tried Show Value As Percent
  of Column, but it always shows 100%.  If I Show Value As Percent of Row, it
  shows what percentage of the total sales of Cat1 was sold for each year.
  i.e. - Cat1 would show 62% for 2006 and 38% for 2007.  Any help would be
  GREATLY appreciated!!!  Thank you!

  --

  --- 
  -
  --
  Some important links for excel users:
  1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip2. Join our LinkedIN group @
 http://www.linkedin.com/groups?gid=1871310
  3. Excel tutorials athttp://www.excel-macros.blogspot.com
  4. Learn VBA Macros athttp://www.quickvba.blogspot.com5. Excel Tips and
  Tricks athttp://exceldailytip.blogspot.com

  To post to this group, send email to excel-macros@googlegroups.com

  
  Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

  --

  --- 
  ---
  Some important links for excel users:
  1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
  2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
  3. Excel tutorials athttp://www.excel-macros.blogspot.com
  4. Learn VBA Macros athttp://www.quickvba.blogspot.com
  5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com

  To post to this group, send email to excel-macros@googlegroups.com

  
  Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel



  sample.xls
 14KViewDownload

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel

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

[XLS S]

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 need to find the percent of sales for each category, for
 each year in my data.

 For instance, if I have:

 Invoice#YearCat1Cat2Cat3
 123456 2006$5.00   $4.00   $3.00
 234567 2006$5.00   $4.00   $3.00
 345678 2006$5.00   $4.00   $3.00
 987654 2007$3.00   $4.00   $5.00
 876543 2007$3.00   $4.00   $5.00
 765432 2007$3.00   $4.00   $5.00

 I need a pivot table that will sum all values for each category by
 year, then tell me what percent of that year's sales belonged to that
 category.  I can get a pivot table to show each category by year with
 total sales like this:

 Values2006   2007
 Cat1   $15.00 $9.00
 Cat2   $12.00 $12.00
 Cat3   $9.00   $15.00

 BUT, I really need the percent of each category for that column.  For
 instance, 2006 and 2007 both have $36.00 total sales.  So I would want
 to know what percent of that $36.00 was for Cat1, Cat2, and Cat3.
 Something like this:

 Values20062007
 Cat1   42% 25%
 Cat2   33% 33%
 Cat3   25% 42%

 Does anybody have any recommendations?  I have tried Show Value As
 Percent of Column, but it always shows 100%.  If I Show Value As
 Percent of Row, it shows what percentage of the total sales of Cat1
 was sold for each year.  i.e. - Cat1 would show 62% for 2006 and 38%
 for 2007.  Any help would be GREATLY appreciated!!!  Thank you!

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


multipal sum.xls
Description: MS-Excel spreadsheet

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

[Robert Jacobs]

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#YearCat1Cat2Cat3
123456 2006$5.00   $4.00   $3.00
234567 2006$5.00   $4.00   $3.00
345678 2006$5.00   $4.00   $3.00
987654 2007$3.00   $4.00   $5.00
876543 2007$3.00   $4.00   $5.00
765432 2007$3.00   $4.00   $5.00

I need a pivot table that will sum all values for each category by
year, then tell me what percent of that year's sales belonged to that
category.  I can get a pivot table to show each category by year with
total sales like this:

Values2006   2007
Cat1   $15.00 $9.00
Cat2   $12.00 $12.00
Cat3   $9.00   $15.00

BUT, I really need the percent of each category for that column.  For
instance, 2006 and 2007 both have $36.00 total sales.  So I would want
to know what percent of that $36.00 was for Cat1, Cat2, and Cat3.
Something like this:

Values20062007
Cat1   42% 25%
Cat2   33% 33%
Cat3   25% 42%

Does anybody have any recommendations?  I have tried Show Value As
Percent of Column, but it always shows 100%.  If I Show Value As
Percent of Row, it shows what percentage of the total sales of Cat1
was sold for each year.  i.e. - Cat1 would show 62% for 2006 and 38%
for 2007.  Any help would be GREATLY appreciated!!!  Thank you!

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[crossy75]

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 individual worksheets,
as individual workbooks with the file name saved as which would be the
tab name if you clicked on the 'show pages.' (ie from tab 'smith' 
tab 'jones' to a file smith.xls with one tab ''smith' and another file
'jones.xls with one tab 'Jones')

I think this might be a 3 stage process in shoing pages,
then doing a loop to move the first sheet to a new workbook
then saving it as the tab name
closing the file
then looping to do the same again till no more sheets are left in the
main workbook

if there is a smarter way please let me know.

ta

Simon

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[ICWAI Help]

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 lists 30 worksheets with each one
 being a separate client and valuation.

 Is there a way instead of showing the pages as individual worksheets,
 as individual workbooks with the file name saved as which would be the
 tab name if you clicked on the 'show pages.' (ie from tab 'smith' 
 tab 'jones' to a file smith.xls with one tab ''smith' and another file
 'jones.xls with one tab 'Jones')

 I think this might be a 3 stage process in shoing pages,
 then doing a loop to move the first sheet to a new workbook
 then saving it as the tab name
 closing the file
 then looping to do the same again till no more sheets are left in the
 main workbook

 if there is a smarter way please let me know.

 ta

 Simon

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[rakesh kumar]

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 users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[rakesh kumar]

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
.Position = 1
End With

With .PivotFields(Q4_Community)
.Orientation = xlColumnField
.Position = 1
End With

With .PivotFields(Q3_Village)
.Orientation = xlPageField
.Position = 1
End With

With .PivotFields(Q3_Village)
.Orientation = xlDataField
.Position = 1
End With

End With
-- 
  Rakesh kumar khowal

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

[rakesh kumar]

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 the excel sheet

 Regards
 Umesh Dev


 On Fri, Apr 1, 2011 at 4:29 PM, rakesh kumar rakeshshail2...@gmail.comwrote:

 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
 range as other two groups don't match the filter criteria. I want the pivot
 table to keep all five groups and if a group doesn't match the filter
 criteria it should show 0 or anything else will just do. any idea ???


 Thanks !!


 --
   Rakesh kumar khowal

  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
  Rakesh kumar khowal
 +91 9868532105

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


test_x.xls
Description: MS-Excel spreadsheet

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

[Jaideep Panchal]

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,


  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 the excel sheet

Regards
Umesh Dev



On Fri, Apr 1, 2011 at 4:29 PM, rakesh kumar rakeshshail2...@gmail.com 
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 
range as other two groups don't match the filter criteria. I want the pivot 
table to keep all five groups and if a group doesn't match the filter criteria 
it should show 0 or anything else will just do. any idea ???




  Thanks !!


  -- 
Rakesh kumar khowal



  -- 
  
--
  Some important links for excel users:
  1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
  2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

  To post to this group, send email to excel-macros@googlegroups.com
   
  
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel




-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel




  -- 
Rakesh kumar khowal
   +91 9868532105


  -- 
  
--
  Some important links for excel users:
  1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
  2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

  To post to this group, send email to excel-macros@googlegroups.com
   
  
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


test_x.xls
Description: MS-Excel spreadsheet