$$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 - VB code

[TheExpat Wanderer]

Good Afternoon Everyone ,
 
Please could you assist me on listing the required data from the attached 
pivot table to  the attached sheet1.
this is my daily work it took me 1 hour to finish it , but I think with a 
VB code it could be done on 1 minute.
I don't know if this could be done by formula.
 
 please reply to me for any clarification.
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

-- 
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 >:
>
>> 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 
>> 
>>
>> -- 
>> 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 .
>> To post to this group, send email to excel-...@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.

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

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 :

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

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


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

[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 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Wed, 30 Oct 2013 11:02:43 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Pivot Table queries
>
> Sandeep please insert required formula using pivot table formula.
> for this go to Options>formula>Calculated 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://ww

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 Options>formula>Calculated 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 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Wed, 30 Oct 2013 11:02:43 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Pivot Table queries
>
> Sandeep please insert required formula using pivot table formula.
> for this go to Options>formula>Calculated 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.c

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 
Sender: excel-macros@googlegroups.com
Date: Wed, 30 Oct 2013 11:02:43 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Pivot Table queries

Sandeep please insert required formula using pivot table formula.
for this go to Options>formula>Calculated Field.
Options Ribbon will populate once 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 subscribe

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

[Anoop K Sharma]

Sandeep please insert required formula using pivot table formula.
for this go to Options>formula>Calculated Field.
Options Ribbon will populate once you select the pivot field and Calculated
field will enable when you select any column field in pivot.




On Wed, Oct 30, 2013 at 8:07 AM, 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.

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

[xlstime]

place "Return type" in column Labels

.

Enjoy
Team XLS



On Tue, Oct 29, 2013 at 1:38 PM, Pravin Gunjal  wrote:

> *Hello,*
> *
> *
> *I have created a pivot table for attached file as per column F, I & M
> from Data Sheet.  *
> *
> *
> *I want the total of return types “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.
<>

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

> 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

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

[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  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 *
Like Us on 
Facebook
Join Us on Facebook 


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.

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

> Hello,
>
> Hope everyone is well. I think I have a really simple question but I am
> struggling!  I am looking for a cumlative total across columns, please see
> example data below:
> Basically I want the first 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.

$$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 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, अनिल नारायण गवली
wrote:

>  [image: Boxbe]  gawlianil8886@gmail.comis 
> not on your
> Guest 
> List|
>  Approve
> sender|
>  Approve
> domain
>
> Dear Nath,
>
> Pl find the attached herewith.
>
> Warm Regards,
> Gawli Anil
>
>
> On Wed, Aug 14, 2013 at 3:09 PM, Gopinath  wrote:
>
>> Dear Shri Satendra Kumar,
>> Thank you for your suggestion.  However, what I wanted is "Running
>> Balance" for each Bank - Datewise as well as "Grand Total Balance"
>> available 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  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-macr

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

[अनिल नारायण गवली]

Dear Nath,

Pl find the attached herewith.

Warm Regards,
Gawli Anil


On Wed, Aug 14, 2013 at 3:09 PM, Gopinath  wrote:

> Dear Shri Satendra Kumar,
> Thank you for your suggestion.  However, what I wanted is "Running
> Balance" for each Bank - Datewise as well as "Grand Total Balance"
> available 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  > wrote:
>
>> Hi Gopi ji,
>>
>> find attach file.
>>
>> thanks
>> satendra
>>
>>
>> On Tue, Aug 13, 2013 at 5:28 PM, Gopi Nath  wrote:
>>
>>> I had attached an Excel file with data and Pivot Table.
>>> What I want is the yellow portion is not to be displayed.
>>> On the other hand, the Grand Total and Company Total should be displayed
>>> 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 t

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

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

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

[Satendra kumar]

Hi Gopi ji,

find attach file.

thanks
satendra


On Tue, Aug 13, 2013 at 5:28 PM, Gopi Nath  wrote:

> I had attached an Excel file with data and Pivot Table.
> What I want is the yellow portion is not to be displayed.
> On the other hand, the Grand Total and Company Total should be displayed
> 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

$$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 FROM MULTIPLE SHEETS

[Amit Gandhi]

How it is to be used?


On Fri, May 17, 2013 at 10:27 AM, Rajan_Verma wrote:

> *Use it *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *P.VIJAYKUMAR
> *Sent:* 17 May 2013 10:19
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-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]

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 
mailto: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> 
[mailto:excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>] On 
Behalf Of xlstime
Sent: 26 March 2013 12:07
To: excel-macros@googlegroups.com<mailto: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 
mailto: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> 
[mailto:excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>] On 
Behalf Of xlstime
Sent: 25 March 2013 17:24
To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Cc: gawlianil8...@gmail.com<mailto:gawlianil8...@gmail.com>
Subject: Re: $$Excel-Macros$$ Pivot table

need more  explanation
.

Enjoy
Team XLS

On Mon, Mar 25, 2013 at 6:00 PM, Manjunath Narayanappa 
mailto:manjunath.narayana...@aon.co.uk>> wrote:
Dear Anil,

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<mailto:excel-macros%2bunsubscr...@googlegroups.com>.
To post to this group, send email to 
excel-macros@googlegroups.com<mailto: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 rec

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 conf

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 
mailto: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> 
[mailto:excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>] On 
Behalf Of xlstime
Sent: 25 March 2013 17:24
To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Cc: gawlianil8...@gmail.com<mailto:gawlianil8...@gmail.com>
Subject: Re: $$Excel-Macros$$ Pivot table

need more  explanation
.

Enjoy
Team XLS

On Mon, Mar 25, 2013 at 6:00 PM, Manjunath Narayanappa 
mailto:manjunath.narayana...@aon.co.uk>> wrote:
Dear Anil,

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<mailto:excel-macros%2bunsubscr...@googlegroups.com>.
To post to this group, send email to 
excel-macros@googlegroups.com<mailto: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<mailto:excel-macros%2bunsubscr...@googlegroups.com>.
To post to this group, send email to 
excel-macros@googlegroups.com<mailto: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

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

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 
mailto: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<mailto:excel-macros%2bunsubscr...@googlegroups.com>.
To post to this group, send email to 
excel-macros@googlegroups.com<mailto: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'

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

>
> Hope the attached file can help you better.
>
> Regards,
> Anoop
> Sr. Developer
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. 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 wrote:

> Possibly, I am getting errors in applying the above criteria. What if I
> can provide you the same applying VBA?
>
> Regards,
> Anoop
> Sr. Developer
>
>
>
> On Tue, Nov 13, 2012 at 10:55 AM, Sheyn Lee  wrote:
>
>> Dear Anoop,
>> I need the values from a pivot table use the formula
>> '=PERCENTILE(C2:C6,0.5)'
>>
>> Best Regrds,
>> S.
>>
>> On Mon, Nov 12, 2012 at 12:56 PM, Anoop K Sharma 
>> wrote:
>>
>>> Sheyn, Please elaborate your query.
>>>
>>> Regards,
>>> Anoop
>>>
>>>
>>> On Sat, Nov 10, 2012 at 2:29 PM, Sheyn Lee  wrote:
>>>
 Dear MS Excel 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

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  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 
> wrote:
>
>> Sheyn, Please elaborate your query.
>>
>> Regards,
>> Anoop
>>
>>
>> On Sat, Nov 10, 2012 at 2:29 PM, Sheyn Lee  wrote:
>>
>>> Dear MS Excel Group,
>>> Can we get percentile values from a pivot table.
>>> Best Regards,
>>> Sheyn
>>>
>>> --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> 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 br

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

> Sheyn, Please elaborate your query.
>
> Regards,
> Anoop
>
>
> On Sat, Nov 10, 2012 at 2:29 PM, Sheyn Lee  wrote:
>
>> Dear MS Excel Group,
>> Can we get percentile values from a pivot table.
>> Best Regards,
>> Sheyn
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> 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  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 9/3/12, Mangesh Vimay  wrote:
> Hi Noorain,
>
> You have sent very good file for learning PT with all options in terms of
> VBA.
> Can you send same kind of file for Chart as well.
> Thanks in Advance.
>
>
>
> On 8/31/12, NOORAIN ANSARI  wrote:
>> Dear Kaushik,
>>
>> Please find attached VBA Pivot Table Template, Hope it will help to you.
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http://
>> noorainansari.com
>> http://
>> excelvbaclinic.com
>>
>>
>>
>> On Fri, Aug 31, 2012 at 6:20 PM, KAUSHIK SAVLA
>> wrote:
>>
>>> 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 allow

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  wrote:
> Dear Kaushik,
>
> Please find attached VBA Pivot Table Template, Hope it will help to you.
>
> --
> With Regards,
> Noorain Ansari
> http://
> noorainansari.com
> http://
> excelvbaclinic.com
>
>
>
> On Fri, Aug 31, 2012 at 6:20 PM, KAUSHIK SAVLA
> wrote:
>
>> 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@googlegro

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

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

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

> Hi
>
> So do i have to copy and paste this formula?
>
>
> On Sun, Apr 15, 2012 at 4:32 PM, Maries  wrote:
>
>> Hi,
>>
>> In that case, Dynamic range is good solution.
>>
>> I have used Name Range "rng" refers 
>> as*=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1))
>> *
>> Regards,
>>
>> MARIES.
>> *
>> *
>> On Mon, Apr 16, 2012 at 12:14 AM, Sara Lee  wrote:
>>
>>> thanks it is good but one change required--- when i add more 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  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 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

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

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

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

Try this formula,

=B4/OFFSET($A$3,COUNTA(A:A)-1,2)

Regards,

MARIES.

On Sun, Apr 15, 2012 at 10:20 PM, Sara Lee  wrote:

> i have created a pivot table in excel in sheet 4 out of sheet 1 data. Now
> i have added a calculation column - right most column of the pivot...
>
> now when i delete 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

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

[NOORAIN ANSARI]

Dear krishnaraddi,

Attached sheet is blank, pls resend

On Wed, Mar 21, 2012 at 6:27 PM, Krishnaraddi  wrote:

> Hi Excel gurus,
>
> I have attached excel sheet consisting of pivot table, For second column
> in the attached sheet I need count. How to achieve this without using
> Macros.
>
> Thanks in advance.
>
> Krish
>
>
> Dear *excel-macros!* 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
>



-- 
Thanks & regards,
Noorain Ansari
 ** *http://noorainansari.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

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

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


On Tue, Mar 20, 2012 at 2:59 PM, Shaik Waheed  wrote:

> Hi,
> Check out the below link
>
> http://www.contextures.com/CreatePivotTable.html
>
> On Tue, Mar 20, 2012 at 2:53 PM, Karan Singh  wrote:
>
>> Dear All,
>>
>> Kindly send me some pivot table examples. I want to learn it.
>>
>>
>> Thanks
>> Kaяan
>>
>>  
>> 
>>
>>
>> --
>> 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

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

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

This is the third time, you posting the same question. Already
issue rectified .

*Please check this link:*

https://groups.google.com/forum/?fromgroups#!searchin/excel-macros/$20the$20file,$20Where$20i$20am$20using$20recording$20macro..$20and$20get$20the$20pivot$20table$20but$20every$20date$20i$20go$20and$20change$20the$20row$20in$20macro$20before$20run,$20Every$20day$20data$20get$20increasin/excel-macros/kvvQZ0HTMTM/1NY_KL1xP3IJ

Keep on forwarding same mail will not help.

If you want any other way of solution, Please reply with details.

Regards,

MARIES.






On Mon, Feb 27, 2012 at 8:29 AM, ashjain2...@yahoo.co.in <
ashjain2...@yahoo.co.in> wrote:

> Dear Boss,
>
> Please find the file, Where i am using recording macro.. and get the pivot
> table but every date i go and change the row in macro before run, Every
> day data get increasingrequest you to please fix the macro so that in
> row will increasing than not need to change row in macro
>
> Exaple :- today i have 2709 Row but tomorrow will be 2810 and day after
> tomorrow it will be 2920 or 3000
>
>
> -
>
> --
> 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

[Prajakt Pande]

Dear Maries,

Thats right good one.

Thanks & Regards,
Prajakt Pande

On Mon, Feb 20, 2012 at 1:58 PM, Maries  wrote:

> *PFA*
>
> On Thu, Feb 16, 2012 at 10:04 AM, Maries  wrote:
>
>>  Hi,
>>
>> Find the attached file. It will work.
>>
>> Sheets("NDC").Select
>> ActiveWorkbook.Names.Add Name:="datas", RefersToR1C1:= _
>> "=OFFSET(NDC!C1,0,0,COUNTA(NDC!C1),COUNTA(NDC!R1))"
>> ActiveWorkbook.Names("datas").Comment = ""
>>
>> Range("A1").Select
>>
>> ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase,
>> SourceData:= _
>> "=datas", Version:=xlPivotTableVersion10). _
>> CreatePivotTable TableDestination:="", TableName:="PivotTable21",
>> _
>> DefaultVersion:=xlPivotTableVersion10
>> ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(3, 1)
>> ActiveSheet.Cells(3, 1).Select
>>
>> The above highlight change done in your coding.
>>
>> Regards,
>>
>> MARIES.
>>
>> On Thu, Feb 16, 2012 at 9:12 AM, ashjain2...@yahoo.co.in <
>> ashjain2...@yahoo.co.in> wrote:
>>
>>> Dear Boss,
>>>
>>> Please find the file, Where i am using recording macro.. and get the
>>> pivot
>>> table but every date i go and change the row in macro before run, Every
>>> day data get increasingrequest you to please fix the macro so that in
>>> row will increasing than not need to change row in macro
>>>
>>> Exaple :- today i have 2709 Row but tomorrow will be 2810 and day after
>>> tomorrow it will be 2920 or 3000
>>>
>>> Ashok
>>> -
>>>
>>> --
>>> 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
>



-- 
Thanks & Regards,
Prajakt Pande
+971551388482
**

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

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  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  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] 
>
> > 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] 
>
> > Hit Back and go to the range selection
>
> > [image: clip_image006] 
>
> > 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/*
>
> > On Tue, Feb 14, 2012 at 6:49 AM, Awal  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

[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  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] 
>
> 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] 
>
> Hit Back and go to the range selection
>
> [image: clip_image006] 
>
> 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/*
>
>
>
>
>
>
>
> On Tue, Feb 14, 2012 at 6:49 AM, Awal  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

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

$$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 (URGENT)

[PrIyAnKa]

You are welcome

On Fri, Jan 20, 2012 at 2:23 PM, Mahreen Ellahi wrote:

> Hey thanks Priyanka, it workss perfectly the way I wanted to thanks alot :)
>
>
> On Fri, Jan 20, 2012 at 12:20 PM, PrIyAnKa  wrote:
>
>> Dear Mahreen
>>
>> Kindly find the attached file and see the yellow highlighted row ,i 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 thr

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

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

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

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

[Shaik Waheed]

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

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 
mailto: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<mailto: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<http://www.excel-macros.blogspot.com/>
4. Learn VBA Macros at 
http://www.quickvba.blogspot.com<http://www.quickvba.blogspot.com/>
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.com<http://exceldailytip.blogspot.com/>

To post to this group, send email to 
excel-macros@googlegroups.com<mailto: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<mailto: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

[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

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

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

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  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  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
>>  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 
>> > 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
>> >>  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 
>> >> > wrote:
>> >> >>
>> >> >> Can u plz mail a sample file.
>> >> >>
>> >> >> On Thu, Sep 1, 2011 at 1:08 PM, John Alliage Tinio Morales
>> >> >>  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
>> >> >> > 
>> >> >> > 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 
>> >> >> >> 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-m

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  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
>  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 
> 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
> >>  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 
> >> > wrote:
> >> >>
> >> >> Can u plz mail a sample file.
> >> >>
> >> >> On Thu, Sep 1, 2011 at 1:08 PM, John Alliage Tinio Morales
> >> >>  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  >
> >> >> > 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 
> >> >> >> 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/exceldai

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

[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
 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  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
>>  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 
>> > wrote:
>> >>
>> >> Can u plz mail a sample file.
>> >>
>> >> On Thu, Sep 1, 2011 at 1:08 PM, John Alliage Tinio Morales
>> >>  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 
>> >> > 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 
>> >> >> 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
>> >> >>
>> >> >> <><><><><><><><><><><><><><><><><><>

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

[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

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 *

On Wed, Aug 31, 2011 at 12:28 PM, Prabhu  wrote:

> Hi Friends,
>
> When i double click my Pivot table value a new sheet is 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**

[suryaprasad . bv]

Can you post the pivoted file plz ?

Thanks
Prasad
Sent from BlackBerry® on Airtel

-Original Message-
From: Prabhu 
Sender: excel-macros@googlegroups.com
Date: Wed, 31 Aug 2011 12:28:10 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ **Pivot Table Doubt**

Hi 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

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

>  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 

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

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

$$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 Percent of Column...

[XLS S]

try formula please find attachment...

On Thu, Aug 25, 2011 at 8:04 PM, Robert Jacobs wrote:

> Thanks in advance experts!!!  This is very complicated to explain, but
> I'll give it a go:
>
> I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3
> Sales), and need to find the 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

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«§  wrote:
> Hi
>
> please find the attachment it may help
>
> --
> *Great day,*
> *viper
>
> *
>
>
>
>
>
>
>
> On Fri, Aug 26, 2011 at 2:13 PM, Daniel  wrote:
> > Have a look at the page :
>
> >http://support.microsoft.com/kb/106359/en-us
>
> > Daniel
>
> > -Message d'origine-
> > De : excel-macros@googlegroups.com [mailto:excel-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 f

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

[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

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

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

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