Re: $$Excel-Macros$$ Pivot Table from multiple sheets
Dear André Luiz D´Avila, Thanks for giving your valuable time for giving reply on my post. But what you replied is very simple and known to be but not useful as because: - 1. The examplese (i.e. columns) in both purchase sale sheet will be more than 50 per sheets. and that too different from each other. 2. What you will do when you have 5000 nos. of purchases and more than 2 000 invoices of sale. Then you will not keep one sheet for both the transactions. I have prepared a very well planned excel program to monitor automatically all the finance / tax accounts related work and my nos of sheets are very high. I want to minimize this by way of getting consolidated report through pivot. Thanks once again. BS On Friday, March 13, 2015 at 7:59:51 PM UTC+5:30, André D'Avila wrote: Hello, You have a excel sheet with table purchase and other one with Sales. In order to combine both of them, the fast way is to create a 3 sheet. In that third one, create another table. Paste de purchase table and below paste the Sales table. After that create a Pivot using this new table. I recommend to create a macro to copy and paste each table constantly. I attached an exemple. André Luiz D´Avila 2015-03-13 10:41 GMT-03:00 B Sharma sharm...@gmail.com javascript:: Dear All Excel Experts, From a very long time, I am trying to create a pivot table using two or more tables, but not getting appropriate results. Please help me , if anybody has ever done so. For e.g. in one table there are purchase details and in another column there are sale details.. I want a combined pivot table which can show both the details at once with showing closing balances. A small database is attached for your reference. I have searched a lot. The reference website is also not as per my needs as pivot table can be created but the result cannot be merged. Thanks in advance. BS -- Consolidate multiple worksheets into one PivotTable report https://support.office.com/en-au/article/Consolidate-multiple-worksheets-into-one-PivotTable-report-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Pivot Table from multiple sheets
Hello, You have a excel sheet with table purchase and other one with Sales. In order to combine both of them, the fast way is to create a 3 sheet. In that third one, create another table. Paste de purchase table and below paste the Sales table. After that create a Pivot using this new table. I recommend to create a macro to copy and paste each table constantly. I attached an exemple. André Luiz D´Avila 2015-03-13 10:41 GMT-03:00 B Sharma sharma@gmail.com: Dear All Excel Experts, From a very long time, I am trying to create a pivot table using two or more tables, but not getting appropriate results. Please help me , if anybody has ever done so. For e.g. in one table there are purchase details and in another column there are sale details.. I want a combined pivot table which can show both the details at once with showing closing balances. A small database is attached for your reference. I have searched a lot. The reference website is also not as per my needs as pivot table can be created but the result cannot be merged. Thanks in advance. BS -- Consolidate multiple worksheets into one PivotTable report https://support.office.com/en-au/article/Consolidate-multiple-worksheets-into-one-PivotTable-report-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Pivot Table from multiple tables.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Pivot Table from multiple sheets
Refer below link https://support.office.com/en-au/article/Consolidate-multiple-worksheets-into-one-PivotTable-report-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5 On 13-Mar-2015 7:12 pm, B Sharma sharma@gmail.com wrote: Dear All Excel Experts, From a very long time, I am trying to create a pivot table using two or more tables, but not getting appropriate results. Please help me , if anybody has ever done so. For e.g. in one table there are purchase details and in another column there are sale details.. I want a combined pivot table which can show both the details at once with showing closing balances. A small database is attached for your reference. I have searched a lot. The reference website is also not as per my needs as pivot table can be created but the result cannot be merged. Thanks in advance. BS -- Consolidate multiple worksheets into one PivotTable report https://support.office.com/en-au/article/Consolidate-multiple-worksheets-into-one-PivotTable-report-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Pivot Table queries
Hi Sandeep, Anoop's earlier suggestion will help you in this also. There is two options in OptionsformulaCalculated Field Calculated Item by using these two options you can create your own formula in pivot table and resulting field will also be a part of pivot table. On Wed, Oct 30, 2013 at 11:15 AM, Sandeep Kumar Chhajer chhajersand...@gmail.com wrote: ** Thanks Anup for your response. One more thing I want to ask is there any way I can use two column of Pivot table for any type of calculation (i.e. the calculation also become part of. Pivot table.) Suppose, with a data set I have derived with two column in a Pivot table, say one is sum and other being count, now I want to work with this two column i.e. Sum column / count column with in pivot table, Is it possible? Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -- *From: * Anoop K Sharma aks.sharm...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Wed, 30 Oct 2013 11:02:43 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Pivot Table queries Sandeep please insert required formula using pivot table formula. for this go to OptionsformulaCalculated Field. Options Ribbon will populate once you select the pivot field and Calculated field will enable when you select any column field in pivot. On Wed, Oct 30, 2013 at 8:07 AM, Sandeep Kumar Chhajer chhajersand...@gmail.com wrote: Hi, Excel gurus, I want to get a column in a pivot table which is comprising of division of two data-source column. Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing
Re: $$Excel-Macros$$ Pivot Table queries
yes, you can play with operators (+,-,/,*) with predefined fields to create new one of your choice. On Wed, Oct 30, 2013 at 11:15 AM, Sandeep Kumar Chhajer chhajersand...@gmail.com wrote: ** Thanks Anup for your response. One more thing I want to ask is there any way I can use two column of Pivot table for any type of calculation (i.e. the calculation also become part of. Pivot table.) Suppose, with a data set I have derived with two column in a Pivot table, say one is sum and other being count, now I want to work with this two column i.e. Sum column / count column with in pivot table, Is it possible? Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -- *From: * Anoop K Sharma aks.sharm...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Wed, 30 Oct 2013 11:02:43 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Pivot Table queries Sandeep please insert required formula using pivot table formula. for this go to OptionsformulaCalculated Field. Options Ribbon will populate once you select the pivot field and Calculated field will enable when you select any column field in pivot. On Wed, Oct 30, 2013 at 8:07 AM, Sandeep Kumar Chhajer chhajersand...@gmail.com wrote: Hi, Excel gurus, I want to get a column in a pivot table which is comprising of division of two data-source column. Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss
Re: $$Excel-Macros$$ Pivot Table Query
place Return type in column Labels . Enjoy Team XLS On Tue, Oct 29, 2013 at 1:38 PM, Pravin Gunjal isk1...@gmail.com wrote: *Hello,* * * *I have created a pivot table for attached file as per column F, I M from Data Sheet. * * * *I want the total of return types “Expiry, Damage/Breakage, Near Expiry” in a first column (column B) and “Saleable” in second column (column C) of pivot table.* * * *Return Type* Saleable Expired Damage/Breakage Near Expiry * * *Could anyone help me out on this. Thanks in advance !!* * * * * *With regards,** **Pravin Gunjal* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. image001.jpg
Re: $$Excel-Macros$$ Pivot Table queries
Sandeep please insert required formula using pivot table formula. for this go to OptionsformulaCalculated Field. Options Ribbon will populate once you select the pivot field and Calculated field will enable when you select any column field in pivot. On Wed, Oct 30, 2013 at 8:07 AM, Sandeep Kumar Chhajer chhajersand...@gmail.com wrote: Hi, Excel gurus, I want to get a column in a pivot table which is comprising of division of two data-source column. Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Pivot Table queries
Thanks Anup for your response. One more thing I want to ask is there any way I can use two column of Pivot table for any type of calculation (i.e. the calculation also become part of. Pivot table.) Suppose, with a data set I have derived with two column in a Pivot table, say one is sum and other being count, now I want to work with this two column i.e. Sum column / count column with in pivot table, Is it possible? Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -Original Message- From: Anoop K Sharma aks.sharm...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 30 Oct 2013 11:02:43 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Pivot Table queries Sandeep please insert required formula using pivot table formula. for this go to OptionsformulaCalculated Field. Options Ribbon will populate once you select the pivot field and Calculated field will enable when you select any column field in pivot. On Wed, Oct 30, 2013 at 8:07 AM, Sandeep Kumar Chhajer chhajersand...@gmail.com wrote: Hi, Excel gurus, I want to get a column in a pivot table which is comprising of division of two data-source column. Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group
RE: $$Excel-Macros$$ Pivot table format
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
not possible in pivot table use separately 1. Select the range that contains blank cells you need to fill. 2. Click Home Find Select Go To Special…, and a Go To Special dialog box will appear, then check Blanks option. 3. Click OK, and all of the blank cells have been selected. Then input the formula “=B2” into active cell B3 without changing the selection. This cell reference can be changed as you need. 4. Press Ctrl + Enter, Excel will copy the respective formula to all blank cells. 5. At this point, the filled contents are formulas, and we need to convert the formals to values. Then select the whole range, right-click to choose Copy, and then press Ctrl + Alt + V to active the Paste Special… dialog box. And select Values option from Paste, and select None option from Operation. 6. Then click OK. And all of the formulas have been converted to values. . Enjoy Team XLS On Sun, Oct 27, 2013 at 1:16 AM, Kashan Abbas kashanabbas...@hotmail.comwrote: Dear Group plz help -- From: kashanabbas...@hotmail.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Pivot table format Date: Sat, 26 Oct 2013 09:54:54 +0500 Dear Plz reply -- From: kashanabbas...@hotmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Pivot table format Date: Fri, 25 Oct 2013 16:38:19 +0500 Dear Expert , I want to repeat date with every record .Reference sheet is attached for your review . Pleas help Thanks. Kashi . -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you
RE: $$Excel-Macros$$ Pivot table format
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
try the attachment see if it helps On Sun, Sep 22, 2013 at 10:26 AM, Bv Dileep bvdil...@gmail.com wrote: Hello All, Can any one provide the macro code to make a pivot table -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Pivot Table Sample.xlsm Description: Binary data
Re: $$Excel-Macros$$ Pivot Table - Cumlative Totals
Please do share your file. On Fri, Sep 20, 2013 at 1:34 AM, Brett Manning brettmannin...@gmail.comwrote: Hello, Hope everyone is well. I think I have a really simple question but I am struggling! I am looking for a cumlative total across columns, please see example data below: Basically I want the first column in the Pivot table to be the Opening value then the next column to take the opening and add today's entries to provide a cumlative balance. Excel Data Name TypeOpeningMovement 1 Movement 2 My AccountBalance 100.00 100.00 100.00 Dave's Account Balance200.00 -100.00 100.00 I would like the Pivot table to display the Opening in the first value column in the pivot table as 100.00 for my account and 200.00 for Dave's account. The 2nd Column for Movement 1 should display 200.00 for My Account (Opening + Movement) and Movement 2 should total 300.00 (Opening + Movement 1 + Movement 2 / or a cumlative running total. Please can offer me some advice, I am sure this is really simple I just cannot work it out. Thanks, Brett -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Pivot Table Running Balance - Grand Total
Hai Friends, Thank you all for your efforts in giving me a solution. However, I wish to state that I want an advanced solution. What I want is - I already have the Running Balance column and I have to get the Grand Total i.e., the last value of the Running Balance under each Bank in the same column. Thank you all for your time. Regards, Gopinath. On Fri, Aug 16, 2013 at 10:03 AM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: [image: Boxbe] https://www.boxbe.com/overview gawlianil8886@gmail.comis not on your Guest Listhttps://www.boxbe.com/approved-list?tc_serial=14887882821tc_rand=376535948utm_source=stfutm_medium=emailutm_campaign=ANNO_MWTPutm_content=001token=DPwUY1dG6RFWm0%2FF35vP3u%2FeWIyRUgAFsM%2FJWc%2B8hMvuiwtGvu9hpSgn%2BSzVZVJFkey=nNO%2F5f5uocSxrwVqcwIhHWkcAbCJBZ577XXdxG6mpJc%3D| Approve senderhttps://www.boxbe.com/anno?tc_serial=14887882821tc_rand=376535948utm_source=stfutm_medium=emailutm_campaign=ANNO_MWTPutm_content=001token=DPwUY1dG6RFWm0%2FF35vP3u%2FeWIyRUgAFsM%2FJWc%2B8hMvuiwtGvu9hpSgn%2BSzVZVJFkey=nNO%2F5f5uocSxrwVqcwIhHWkcAbCJBZ577XXdxG6mpJc%3D| Approve domainhttps://www.boxbe.com/anno?tc_serial=14887882821tc_rand=376535948utm_source=stfutm_medium=emailutm_campaign=ANNO_MWTPutm_content=001domtoken=DPwUY1dG6RFWm0%2FF35vP3u%2FeWIyRUgAFsM%2FJWc%2B8hMvuiwtGvu9hpSgn%2BSzVZVJFkey=nNO%2F5f5uocSxrwVqcwIhHWkcAbCJBZ577XXdxG6mpJc%3D Dear Nath, Pl find the attached herewith. Warm Regards, Gawli Anil On Wed, Aug 14, 2013 at 3:09 PM, Gopinath nath@gmail.com wrote: Dear Shri Satendra Kumar, Thank you for your suggestion. However, what I wanted is Running Balance for each Bank - Datewise as well as Grand Total Balance available for each Bank, both in One Column of the Pivot Table. Thank you once again for your assistance. Gopinath A K On Tue, Aug 13, 2013 at 5:40 PM, Satendra kumar satendrakuma...@gmail.com wrote: Hi Gopi ji, find attach file. thanks satendra On Tue, Aug 13, 2013 at 5:28 PM, Gopi Nath nath@gmail.com wrote: I had attached an Excel file with data and Pivot Table. What I want is the yellow portion is not to be displayed. On the other hand, the Grand Total and Company Total should be displayed under the Running Balance column. Looking for kind assistance please. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Thanks Regards Satendra Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/0Yibyryyan8/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- A K Gopinath Plot No.16, Rafi Nagar Rear
Re: $$Excel-Macros$$ Pivot Table Running Balance - Grand Total
Dear Nath, Pl find the attached herewith. Warm Regards, Gawli Anil On Wed, Aug 14, 2013 at 3:09 PM, Gopinath nath@gmail.com wrote: Dear Shri Satendra Kumar, Thank you for your suggestion. However, what I wanted is Running Balance for each Bank - Datewise as well as Grand Total Balance available for each Bank, both in One Column of the Pivot Table. Thank you once again for your assistance. Gopinath A K On Tue, Aug 13, 2013 at 5:40 PM, Satendra kumar satendrakuma...@gmail.com wrote: Hi Gopi ji, find attach file. thanks satendra On Tue, Aug 13, 2013 at 5:28 PM, Gopi Nath nath@gmail.com wrote: I had attached an Excel file with data and Pivot Table. What I want is the yellow portion is not to be displayed. On the other hand, the Grand Total and Company Total should be displayed under the Running Balance column. Looking for kind assistance please. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Thanks Regards Satendra Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/0Yibyryyan8/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- A K Gopinath Plot No.16, Rafi Nagar Rear Salamathnagar Tank Walaja - 632 513 Vellore District, T.N. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus
Re: $$Excel-Macros$$ Pivot Table Running Balance - Grand Total
Dear Shri Satendra Kumar, Thank you for your suggestion. However, what I wanted is Running Balance for each Bank - Datewise as well as Grand Total Balance available for each Bank, both in One Column of the Pivot Table. Thank you once again for your assistance. Gopinath A K On Tue, Aug 13, 2013 at 5:40 PM, Satendra kumar satendrakuma...@gmail.comwrote: Hi Gopi ji, find attach file. thanks satendra On Tue, Aug 13, 2013 at 5:28 PM, Gopi Nath nath@gmail.com wrote: I had attached an Excel file with data and Pivot Table. What I want is the yellow portion is not to be displayed. On the other hand, the Grand Total and Company Total should be displayed under the Running Balance column. Looking for kind assistance please. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Thanks Regards Satendra Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/0Yibyryyan8/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- A K Gopinath Plot No.16, Rafi Nagar Rear Salamathnagar Tank Walaja - 632 513 Vellore District, T.N. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Pivot Table Running Balance - Grand Total
Respected GopiNath, Please check the following youtube video for your answer http://www.youtube.com/watch?v=Rr9dK5bDWcE Regards, Vijaykumar On Wed, Aug 14, 2013 at 3:09 PM, Gopinath nath@gmail.com wrote: Dear Shri Satendra Kumar, Thank you for your suggestion. However, what I wanted is Running Balance for each Bank - Datewise as well as Grand Total Balance available for each Bank, both in One Column of the Pivot Table. Thank you once again for your assistance. Gopinath A K On Tue, Aug 13, 2013 at 5:40 PM, Satendra kumar satendrakuma...@gmail.com wrote: Hi Gopi ji, find attach file. thanks satendra On Tue, Aug 13, 2013 at 5:28 PM, Gopi Nath nath@gmail.com wrote: I had attached an Excel file with data and Pivot Table. What I want is the yellow portion is not to be displayed. On the other hand, the Grand Total and Company Total should be displayed under the Running Balance column. Looking for kind assistance please. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Thanks Regards Satendra Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/0Yibyryyan8/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- A K Gopinath Plot No.16, Rafi Nagar Rear Salamathnagar Tank Walaja - 632 513 Vellore District, T.N. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Pivot Table Running Balance - Grand Total
Hi Gopi ji, find attach file. thanks satendra On Tue, Aug 13, 2013 at 5:28 PM, Gopi Nath nath@gmail.com wrote: I had attached an Excel file with data and Pivot Table. What I want is the yellow portion is not to be displayed. On the other hand, the Grand Total and Company Total should be displayed under the Running Balance column. Looking for kind assistance please. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Thanks Regards Satendra Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. BankBook.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ PIVOT TABLE FROM MULTIPLE SHEETS
How it is to be used? On Fri, May 17, 2013 at 10:27 AM, Rajan_Verma rajanverma1...@gmail.comwrote: *Use it * * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *P.VIJAYKUMAR *Sent:* 17 May 2013 10:19 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ PIVOT TABLE FROM MULTIPLE SHEETS ** ** Respected Experts, ** ** Is it possible to create a pivot table taking data (or fields) from different sheets of the workbook. ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** Regards, P.VIJAY KUMAR -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 'Expecting the world to treat u fairly coz u r a good person is like expecting the lion not to attack u coz u r a vegetarian. Think about it.' Take care Amit -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
RE: $$Excel-Macros$$ Pivot table
Dear Experts Everyday I need to create pivot table to find the Age of each case( Query , WIP, untouched, draft) Is there any way to assign macro to the report Thanks Manjunath From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of xlstime Sent: 25 March 2013 17:24 To: excel-macros@googlegroups.com Cc: gawlianil8...@gmail.com Subject: Re: $$Excel-Macros$$ Pivot table need more explanation . Enjoy Team XLS On Mon, Mar 25, 2013 at 6:00 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.ukmailto:manjunath.narayana...@aon.co.uk wrote: Dear Anil, Further to the above attached, With the help of macros can we run pivot table for the data which is available in sheet1 extract same to sheet 2(Pivot table) So I can find the age of the case . In sheet 2 from pivot table can we pulling same information to DSR(which is highlight in Pink) Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Services Authority in respect of insurance mediation activities only. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.commailto:excel-macros%2bunsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Services Authority in respect of insurance mediation activities only. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions
Re: $$Excel-Macros$$ Pivot table
Hi Maniunath, if headers are fixed then i think no need for create pivot-table on daily.. just refresh pivot daily ... . Enjoy Team XLS On Tue, Mar 26, 2013 at 3:42 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.uk wrote: Dear Experts Everyday I need to create pivot table to find the Age of each case( Query , WIP, untouched, draft) Is there any way to assign macro to the report Thanks Manjunath *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *xlstime *Sent:* 25 March 2013 17:24 *To:* excel-macros@googlegroups.com *Cc:* gawlianil8...@gmail.com *Subject:* Re: $$Excel-Macros$$ Pivot table need more explanation . Enjoy Team XLS On Mon, Mar 25, 2013 at 6:00 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.uk wrote: Dear Anil, Further to the above attached, With the help of macros can we run pivot table for the data which is available in sheet1 extract same to sheet 2(Pivot table) So I can find the age of the case . In sheet 2 from pivot table can we pulling same information to DSR(which is highlight in Pink) Thanks Manjunath -- PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon’s standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Services Authority in respect of insurance mediation activities only. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon’s standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Services Authority in respect of insurance mediation activities only. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles
RE: $$Excel-Macros$$ Pivot table
But every day i need to run report update in fresh spreadsheet From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of xlstime Sent: 26 March 2013 12:07 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Pivot table Hi Maniunath, if headers are fixed then i think no need for create pivot-table on daily.. just refresh pivot daily ... . Enjoy Team XLS On Tue, Mar 26, 2013 at 3:42 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.ukmailto:manjunath.narayana...@aon.co.uk wrote: Dear Experts Everyday I need to create pivot table to find the Age of each case( Query , WIP, untouched, draft) Is there any way to assign macro to the report Thanks Manjunath From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On Behalf Of xlstime Sent: 25 March 2013 17:24 To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Cc: gawlianil8...@gmail.commailto:gawlianil8...@gmail.com Subject: Re: $$Excel-Macros$$ Pivot table need more explanation . Enjoy Team XLS On Mon, Mar 25, 2013 at 6:00 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.ukmailto:manjunath.narayana...@aon.co.uk wrote: Dear Anil, Further to the above attached, With the help of macros can we run pivot table for the data which is available in sheet1 extract same to sheet 2(Pivot table) So I can find the age of the case . In sheet 2 from pivot table can we pulling same information to DSR(which is highlight in Pink) Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Services Authority in respect of insurance mediation activities only. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.commailto:excel-macros%2bunsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.commailto:excel-macros%2bunsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions associated with this e-mail please visit http://www.aon.com/uk/en
Re: $$Excel-Macros$$ Pivot table
.. please check below link http://vbadud.blogspot.in/2008/05/create-pivot-table-using-excel-vba.html . Enjoy Team XLS On Tue, Mar 26, 2013 at 5:51 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.uk wrote: But every day i need to run report update in fresh spreadsheet *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *xlstime *Sent:* 26 March 2013 12:07 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Pivot table Hi Maniunath, if headers are fixed then i think no need for create pivot-table on daily.. just refresh pivot daily ... . Enjoy Team XLS On Tue, Mar 26, 2013 at 3:42 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.uk wrote: Dear Experts Everyday I need to create pivot table to find the Age of each case( Query , WIP, untouched, draft) Is there any way to assign macro to the report Thanks Manjunath *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *xlstime *Sent:* 25 March 2013 17:24 *To:* excel-macros@googlegroups.com *Cc:* gawlianil8...@gmail.com *Subject:* Re: $$Excel-Macros$$ Pivot table need more explanation . Enjoy Team XLS On Mon, Mar 25, 2013 at 6:00 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.uk wrote: Dear Anil, Further to the above attached, With the help of macros can we run pivot table for the data which is available in sheet1 extract same to sheet 2(Pivot table) So I can find the age of the case . In sheet 2 from pivot table can we pulling same information to DSR(which is highlight in Pink) Thanks Manjunath -- PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon’s standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Services Authority in respect of insurance mediation activities only. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon’s standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/email
RE: $$Excel-Macros$$ Pivot table
It's not working it shows a syntax error in line From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of xlstime Sent: 26 March 2013 12:44 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Pivot table .. please check below link http://vbadud.blogspot.in/2008/05/create-pivot-table-using-excel-vba.html . Enjoy Team XLS On Tue, Mar 26, 2013 at 5:51 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.ukmailto:manjunath.narayana...@aon.co.uk wrote: But every day i need to run report update in fresh spreadsheet From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On Behalf Of xlstime Sent: 26 March 2013 12:07 To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Pivot table Hi Maniunath, if headers are fixed then i think no need for create pivot-table on daily.. just refresh pivot daily ... . Enjoy Team XLS On Tue, Mar 26, 2013 at 3:42 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.ukmailto:manjunath.narayana...@aon.co.uk wrote: Dear Experts Everyday I need to create pivot table to find the Age of each case( Query , WIP, untouched, draft) Is there any way to assign macro to the report Thanks Manjunath From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On Behalf Of xlstime Sent: 25 March 2013 17:24 To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Cc: gawlianil8...@gmail.commailto:gawlianil8...@gmail.com Subject: Re: $$Excel-Macros$$ Pivot table need more explanation . Enjoy Team XLS On Mon, Mar 25, 2013 at 6:00 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.ukmailto:manjunath.narayana...@aon.co.uk wrote: Dear Anil, Further to the above attached, With the help of macros can we run pivot table for the data which is available in sheet1 extract same to sheet 2(Pivot table) So I can find the age of the case . In sheet 2 from pivot table can we pulling same information to DSR(which is highlight in Pink) Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Services Authority in respect of insurance mediation activities only. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.commailto:excel-macros%2bunsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL
Re: $$Excel-Macros$$ Pivot table
need more explanation . Enjoy Team XLS On Mon, Mar 25, 2013 at 6:00 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.uk wrote: Dear Anil, Further to the above attached, With the help of macros can we run pivot table for the data which is available in sheet1 extract same to sheet 2(Pivot table) So I can find the age of the case . In sheet 2 from pivot table can we pulling same information to DSR(which is highlight in Pink) Thanks Manjunath -- PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon’s standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Services Authority in respect of insurance mediation activities only. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Pivot table
PFA.. On Wed, Jan 9, 2013 at 1:27 PM, Anoop K Sharma aks.sharm...@gmail.comwrote: Hope the attached file can help you better. Regards, Anoop Sr. Developer -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Copy of Pivot table.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Pivot table
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
Thank you Anoop for your hlep but probably for us VBA is a not a solution. Once again many thanks for time and effort. S. On Mon, Nov 19, 2012 at 9:16 AM, Anoop K Sharma aks.sharm...@gmail.comwrote: Possibly, I am getting errors in applying the above criteria. What if I can provide you the same applying VBA? Regards, Anoop Sr. Developer On Tue, Nov 13, 2012 at 10:55 AM, Sheyn Lee sheyn...@gmail.com wrote: Dear Anoop, I need the values from a pivot table use the formula '=PERCENTILE(C2:C6,0.5)' Best Regrds, S. On Mon, Nov 12, 2012 at 12:56 PM, Anoop K Sharma aks.sharm...@gmail.comwrote: Sheyn, Please elaborate your query. Regards, Anoop On Sat, Nov 10, 2012 at 2:29 PM, Sheyn Lee sheyn...@gmail.com wrote: Dear MS Excel Group, Can we get percentile values from a pivot table. Best Regards, Sheyn -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards, Anoop -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards, Anoop -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding
Re: $$Excel-Macros$$ Pivot Table - Required percentile values
Possibly, I am getting errors in applying the above criteria. What if I can provide you the same applying VBA? Regards, Anoop Sr. Developer On Tue, Nov 13, 2012 at 10:55 AM, Sheyn Lee sheyn...@gmail.com wrote: Dear Anoop, I need the values from a pivot table use the formula '=PERCENTILE(C2:C6,0.5)' Best Regrds, S. On Mon, Nov 12, 2012 at 12:56 PM, Anoop K Sharma aks.sharm...@gmail.comwrote: Sheyn, Please elaborate your query. Regards, Anoop On Sat, Nov 10, 2012 at 2:29 PM, Sheyn Lee sheyn...@gmail.com wrote: Dear MS Excel Group, Can we get percentile values from a pivot table. Best Regards, Sheyn -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards, Anoop -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards, Anoop -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post
Re: $$Excel-Macros$$ Pivot Table - Required percentile values
Dear Anoop, I need the values from a pivot table use the formula '=PERCENTILE(C2:C6,0.5)' Best Regrds, S. On Mon, Nov 12, 2012 at 12:56 PM, Anoop K Sharma aks.sharm...@gmail.comwrote: Sheyn, Please elaborate your query. Regards, Anoop On Sat, Nov 10, 2012 at 2:29 PM, Sheyn Lee sheyn...@gmail.com wrote: Dear MS Excel Group, Can we get percentile values from a pivot table. Best Regards, Sheyn -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards, Anoop -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Pivot Table - Required percentile values
Sheyn, Please elaborate your query. Regards, Anoop On Sat, Nov 10, 2012 at 2:29 PM, Sheyn Lee sheyn...@gmail.com wrote: Dear MS Excel Group, Can we get percentile values from a pivot table. Best Regards, Sheyn -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards, Anoop -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Pivot Table Vba Help needed
Hi Noorain, You have sent very good file for learning PT with all options in terms of VBA. Can you send same kind of file for Chart as well. Thanks in Advance. On 8/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Kaushik, Please find attached VBA Pivot Table Template, Hope it will help to you. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com On Fri, Aug 31, 2012 at 6:20 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: Hi All, *Need your help to perform the attached task.* * * *What I am doing is as below:=* * * *1. I am having the data in the Data tab of the file* *2. I want to create the Pivot table based on the Data tab with Criteria as Row Labels: Supplier and Values: Sum of Amount.* *3. Then I want to extract the details of each supplier in different tab so as to create an invoice for the individual supplier showing them the transactions during the amount. The extracted data should automatically extract data from pivot for as many supplier available. In the attached file as instance there are 4 suppliers namely A,B,C,D.* *4. The extracted data should automatically rename the worksheet tab containing the name of supplier.* * * *Looking forward for your prompt response.* * * *Regards,* *Kaushik Savla* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Pivot Table Vba Help needed
Hi Noorain, You have sent very good file for learning PT with all options in terms of VBA. Can you send same kind of file for Chart as well. Thanks in Advance. On 9/3/12, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Noorain, You have sent very good file for learning PT with all options in terms of VBA. Can you send same kind of file for Chart as well. Thanks in Advance. On 8/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Kaushik, Please find attached VBA Pivot Table Template, Hope it will help to you. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com On Fri, Aug 31, 2012 at 6:20 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: Hi All, *Need your help to perform the attached task.* * * *What I am doing is as below:=* * * *1. I am having the data in the Data tab of the file* *2. I want to create the Pivot table based on the Data tab with Criteria as Row Labels: Supplier and Values: Sum of Amount.* *3. Then I want to extract the details of each supplier in different tab so as to create an invoice for the individual supplier showing them the transactions during the amount. The extracted data should automatically extract data from pivot for as many supplier available. In the attached file as instance there are 4 suppliers namely A,B,C,D.* *4. The extracted data should automatically rename the worksheet tab containing the name of supplier.* * * *Looking forward for your prompt response.* * * *Regards,* *Kaushik Savla* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- With regards, *MaNgEsH* -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are
Re: $$Excel-Macros$$ Pivot table with chart represent
hi why do u want to use vba . simple make the dynamic range and add it to the source of pivot whenever u will add or delete the data in source sheet it will automatically get updated try the attachment visit to know more abt http://www.contextures.com/xlPivot01.html On Sun, Jul 29, 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
Re: $$Excel-Macros$$ Pivot table
Hi, Try this formula, =B4/OFFSET($A$3,COUNTA(A:A)-1,2) Regards, MARIES. On Sun, Apr 15, 2012 at 10:20 PM, Sara Lee lee.sar...@gmail.com wrote: i have created a pivot table in excel in sheet 4 out of sheet 1 data. Now i have added a calculation column - right most column of the pivot... now when i delete the row of the data in sheet 1 say mumbai row, and then refresh the pivot... then the last column gets messed up showing div/0 error is therer any way to correct that last column formula in the pivot so that it updates itself when data is refresehed. thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Pivot Calculation.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Pivot table
thanks it is good but one change required--- when i add more records into my base sheet , and then refresh the pivot, that column % does not get updated automatically;; also when i delete records, that column shows up 0 even though there are no records to left On Sun, Apr 15, 2012 at 3:41 PM, Maries talk2mar...@gmail.com wrote: Hi, Try this formula, =B4/OFFSET($A$3,COUNTA(A:A)-1,2) Regards, MARIES. On Sun, Apr 15, 2012 at 10:20 PM, Sara Lee lee.sar...@gmail.com wrote: i have created a pivot table in excel in sheet 4 out of sheet 1 data. Now i have added a calculation column - right most column of the pivot... now when i delete the row of the data in sheet 1 say mumbai row, and then refresh the pivot... then the last column gets messed up showing div/0 error is therer any way to correct that last column formula in the pivot so that it updates itself when data is refresehed. thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Pivot table
Hi, In that case, Dynamic range is good solution. I have used Name Range rng refers as*=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1)) * Regards, MARIES.* * On Mon, Apr 16, 2012 at 12:14 AM, Sara Lee lee.sar...@gmail.com wrote: thanks it is good but one change required--- when i add more records into my base sheet , and then refresh the pivot, that column % does not get updated automatically;; also when i delete records, that column shows up 0 even though there are no records to left On Sun, Apr 15, 2012 at 3:41 PM, Maries talk2mar...@gmail.com wrote: Hi, Try this formula, =B4/OFFSET($A$3,COUNTA(A:A)-1,2) Regards, MARIES. On Sun, Apr 15, 2012 at 10:20 PM, Sara Lee lee.sar...@gmail.com wrote: i have created a pivot table in excel in sheet 4 out of sheet 1 data. Now i have added a calculation column - right most column of the pivot... now when i delete the row of the data in sheet 1 say mumbai row, and then refresh the pivot... then the last column gets messed up showing div/0 error is therer any way to correct that last column formula in the pivot so that it updates itself when data is refresehed. thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Pivot Calculation.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Pivot table
Hi So do i have to copy and paste this formula? On Sun, Apr 15, 2012 at 4:32 PM, Maries talk2mar...@gmail.com wrote: Hi, In that case, Dynamic range is good solution. I have used Name Range rng refers as*=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1)) * Regards, MARIES. * * On Mon, Apr 16, 2012 at 12:14 AM, Sara Lee lee.sar...@gmail.com wrote: thanks it is good but one change required--- when i add more records into my base sheet , and then refresh the pivot, that column % does not get updated automatically;; also when i delete records, that column shows up 0 even though there are no records to left On Sun, Apr 15, 2012 at 3:41 PM, Maries talk2mar...@gmail.com wrote: Hi, Try this formula, =B4/OFFSET($A$3,COUNTA(A:A)-1,2) Regards, MARIES. On Sun, Apr 15, 2012 at 10:20 PM, Sara Lee lee.sar...@gmail.com wrote: i have created a pivot table in excel in sheet 4 out of sheet 1 data. Now i have added a calculation column - right most column of the pivot... now when i delete the row of the data in sheet 1 say mumbai row, and then refresh the pivot... then the last column gets messed up showing div/0 error is therer any way to correct that last column formula in the pivot so that it updates itself when data is refresehed. thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
Re: $$Excel-Macros$$ Pivot table
Hi, To get the percentage, *Copy paste* or *Drag Down* the formula from * Sheet1-D4*. On Mon, Apr 16, 2012 at 1:10 AM, Sara Lee lee.sar...@gmail.com wrote: Hi So do i have to copy and paste this formula? On Sun, Apr 15, 2012 at 4:32 PM, Maries talk2mar...@gmail.com wrote: Hi, In that case, Dynamic range is good solution. I have used Name Range rng refers as*=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1)) * Regards, MARIES. * * On Mon, Apr 16, 2012 at 12:14 AM, Sara Lee lee.sar...@gmail.com wrote: thanks it is good but one change required--- when i add more records into my base sheet , and then refresh the pivot, that column % does not get updated automatically;; also when i delete records, that column shows up 0 even though there are no records to left On Sun, Apr 15, 2012 at 3:41 PM, Maries talk2mar...@gmail.com wrote: Hi, Try this formula, =B4/OFFSET($A$3,COUNTA(A:A)-1,2) Regards, MARIES. On Sun, Apr 15, 2012 at 10:20 PM, Sara Lee lee.sar...@gmail.comwrote: i have created a pivot table in excel in sheet 4 out of sheet 1 data. Now i have added a calculation column - right most column of the pivot... now when i delete the row of the data in sheet 1 say mumbai row, and then refresh the pivot... then the last column gets messed up showing div/0 error is therer any way to correct that last column formula in the pivot so that it updates itself when data is refresehed. thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for
Re: $$Excel-Macros$$ Pivot table
Dear krishnaraddi, Attached sheet is blank, pls resend On Wed, Mar 21, 2012 at 6:27 PM, Krishnaraddi excelkris...@in.com wrote: Hi Excel gurus, I have attached excel sheet consisting of pivot table, For second column in the attached sheet I need count. How to achieve this without using Macros. Thanks in advance. Krish Dear *excel-macros!* Get Yourself a cool, short *@in.com* Email ID now!http://www3.in.com/sso/commonregister.php?ref=INutm_source=inviteutm_medium=outgoing -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Pivot Table
Hi, Check out the below link http://www.contextures.com/CreatePivotTable.html On Tue, Mar 20, 2012 at 2:53 PM, Karan Singh karan1...@gmail.com wrote: Dear All, Kindly send me some pivot table examples. I want to learn it. Thanks Kaяan http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237 https://plus.google.com/43524614789164919/posts -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Pivot Table
Hi Karan, Try to download *Excel 2007 PivotTables Recipes.pdf * book by 2007 by Debra Dalgleish Or you can search in youtube for Video's tutorial.. *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Tue, Mar 20, 2012 at 2:59 PM, Shaik Waheed waheedb...@gmail.com wrote: Hi, Check out the below link http://www.contextures.com/CreatePivotTable.html On Tue, Mar 20, 2012 at 2:53 PM, Karan Singh karan1...@gmail.com wrote: Dear All, Kindly send me some pivot table examples. I want to learn it. Thanks Kaяan http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237 https://plus.google.com/43524614789164919/posts -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- * * * * -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Pivot Table data range update
Hi, Please use below codes for updates last used row last used column in Pivot Tables. Sheets(Sheet1).Select ActiveWorkbook.Names.Add Name:=Sheet1, RefersToR1C1:= _ =OFFSET(Sheet1!C1,0,0,COUNTA(Sheet1!C1),COUNTA(Sheet1!R1)) ActiveWorkbook.Names(AfterEntry).Comment = Regards, MARIES. On Wed, Feb 15, 2012 at 7:18 AM, anandydr anand...@gmail.com wrote: Although I have not tested it on Excel 2010 in Excel 2007 the shortcut key to Name Manager dialog box is Ctrl + F3 I hope it works for 2010 also. As for explanation given by Noorain it's excellent and most complete. You can also achieve this through VBA but it would effect the speed/ performance of your spreadsheet. Warm Regards, Anand Kumar On Feb 15, 6:15 am, Awal malaw...@gmail.com wrote: Thanks Noorain. That was very thorough. I am using excel 2010 but I can find the Name Manager. I will encourage all our Excel gurus to follow your footsteps. This little tutorial made me like this forum even more!!! Thanks a lot and best regards. On Feb 13, 11:11 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Awal, Please use it Press CTRL F3 or go to Edit Insert Name Define Name your range – e.g. pivot_table_data1 In the refers to section type or copy and paste this formulas =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1)) or =Sheet1!$A$1:INDEX(Sheet1!$A:$F,COUNTA(Sheet1!$A:$A),6) [image: clip_image002] http://www.spyjournal.biz/files/clip_image002_0.jpg Assuming that your data starts in cell A1 of Sheet1. Edit accordingly before pasting in What this formula does is creates an array that starts at cell a1 goes zero cells down and zero cells right, and is x cells deep and y cells wide. x = the count of all non blank cells in column A and y the count of all non blank cells in row 1. Assumes that column A and row 1 are contiguous data blocks the same length and width as the whole data set. If not use columns and rows that are. Now in your pivot table right click and go to Pivot Table Wizard [image: clip_image004] http://www.spyjournal.biz/files/clip_image004_1.jpg Hit Back and go to the range selection [image: clip_image006] http://www.spyjournal.biz/files/clip_image006_1.jpg Type = and the range name = e.g. =pivot_table_data1 In my case my range name was called test. Hit Finish and it is done. Now whenever you paste more data into the data sheet the pivot table just needs to be refreshed to pick it up Click anywhere on the pivot table and click the exclamation mark in the toolbar. The instructions above assume you are using office 2003. In office 2007 the Name Manager is a little more confusing, but can be accessed with the same keyboard shortcut and you will need to create a new range name and then use the same formula listed above. -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* http://excelmacroworld.blogspot.com/ On Tue, Feb 14, 2012 at 6:49 AM, Awal malaw...@gmail.com wrote: I have code to query a database and return data to the data sheet. The number of rows of data returned will vary. Through VBA code, how do I tell the pivot table to update the range of the source data (which is really to update the last row). (Selecting CTRL-End, goes past where the actual data ends) Thank you. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- --- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures
Re: $$Excel-Macros$$ Pivot Table data range update
Thanks Noorain. That was very thorough. I am using excel 2010 but I can find the Name Manager. I will encourage all our Excel gurus to follow your footsteps. This little tutorial made me like this forum even more!!! Thanks a lot and best regards. On Feb 13, 11:11 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Awal, Please use it Press CTRL F3 or go to Edit Insert Name Define Name your range – e.g. pivot_table_data1 In the refers to section type or copy and paste this formulas =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1)) or =Sheet1!$A$1:INDEX(Sheet1!$A:$F,COUNTA(Sheet1!$A:$A),6) [image: clip_image002] http://www.spyjournal.biz/files/clip_image002_0.jpg Assuming that your data starts in cell A1 of Sheet1. Edit accordingly before pasting in What this formula does is creates an array that starts at cell a1 goes zero cells down and zero cells right, and is x cells deep and y cells wide. x = the count of all non blank cells in column A and y the count of all non blank cells in row 1. Assumes that column A and row 1 are contiguous data blocks the same length and width as the whole data set. If not use columns and rows that are. Now in your pivot table right click and go to Pivot Table Wizard [image: clip_image004] http://www.spyjournal.biz/files/clip_image004_1.jpg Hit Back and go to the range selection [image: clip_image006] http://www.spyjournal.biz/files/clip_image006_1.jpg Type = and the range name = e.g. =pivot_table_data1 In my case my range name was called test. Hit Finish and it is done. Now whenever you paste more data into the data sheet the pivot table just needs to be refreshed to pick it up Click anywhere on the pivot table and click the exclamation mark in the toolbar. The instructions above assume you are using office 2003. In office 2007 the Name Manager is a little more confusing, but can be accessed with the same keyboard shortcut and you will need to create a new range name and then use the same formula listed above. -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Tue, Feb 14, 2012 at 6:49 AM, Awal malaw...@gmail.com wrote: I have code to query a database and return data to the data sheet. The number of rows of data returned will vary. Through VBA code, how do I tell the pivot table to update the range of the source data (which is really to update the last row). (Selecting CTRL-End, goes past where the actual data ends) Thank you. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- --- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Pivot Table data range update
Although I have not tested it on Excel 2010 in Excel 2007 the shortcut key to Name Manager dialog box is Ctrl + F3 I hope it works for 2010 also. As for explanation given by Noorain it's excellent and most complete. You can also achieve this through VBA but it would effect the speed/ performance of your spreadsheet. Warm Regards, Anand Kumar On Feb 15, 6:15 am, Awal malaw...@gmail.com wrote: Thanks Noorain. That was very thorough. I am using excel 2010 but I can find the Name Manager. I will encourage all our Excel gurus to follow your footsteps. This little tutorial made me like this forum even more!!! Thanks a lot and best regards. On Feb 13, 11:11 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Awal, Please use it Press CTRL F3 or go to Edit Insert Name Define Name your range – e.g. pivot_table_data1 In the refers to section type or copy and paste this formulas =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1)) or =Sheet1!$A$1:INDEX(Sheet1!$A:$F,COUNTA(Sheet1!$A:$A),6) [image: clip_image002] http://www.spyjournal.biz/files/clip_image002_0.jpg Assuming that your data starts in cell A1 of Sheet1. Edit accordingly before pasting in What this formula does is creates an array that starts at cell a1 goes zero cells down and zero cells right, and is x cells deep and y cells wide. x = the count of all non blank cells in column A and y the count of all non blank cells in row 1. Assumes that column A and row 1 are contiguous data blocks the same length and width as the whole data set. If not use columns and rows that are. Now in your pivot table right click and go to Pivot Table Wizard [image: clip_image004] http://www.spyjournal.biz/files/clip_image004_1.jpg Hit Back and go to the range selection [image: clip_image006] http://www.spyjournal.biz/files/clip_image006_1.jpg Type = and the range name = e.g. =pivot_table_data1 In my case my range name was called test. Hit Finish and it is done. Now whenever you paste more data into the data sheet the pivot table just needs to be refreshed to pick it up Click anywhere on the pivot table and click the exclamation mark in the toolbar. The instructions above assume you are using office 2003. In office 2007 the Name Manager is a little more confusing, but can be accessed with the same keyboard shortcut and you will need to create a new range name and then use the same formula listed above. -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Tue, Feb 14, 2012 at 6:49 AM, Awal malaw...@gmail.com wrote: I have code to query a database and return data to the data sheet. The number of rows of data returned will vary. Through VBA code, how do I tell the pivot table to update the range of the source data (which is really to update the last row). (Selecting CTRL-End, goes past where the actual data ends) Thank you. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- --- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Pivot Table from two separate sheets
Hi, can u send a sample data sheet On Fri, Feb 3, 2012 at 6:18 PM, B Sharma sharma@gmail.com wrote: Hello Friends. I have two sheets For E.g. 1. Opening Balances and purchases of goods 2. Consumption of goods Both the sheets will contain many colours like. purchase date,consumption date, inv. no. party name., item, qty. , values, etc. Now I need to create a Pivot table, in which it will look like this Month - Op. Bal. - Purchase - Consumption - Cl.Bal. I need to import the data from two separate sheets here and show report in one report. Thanks Regards, BS -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Pivot Table from two separate sheets
If you are using excel 2007+ then install this add-in On Fri, Feb 3, 2012 at 6:18 PM, B Sharma sharma@gmail.com wrote: Hello Friends. I have two sheets For E.g. 1. Opening Balances and purchases of goods 2. Consumption of goods Both the sheets will contain many colours like. purchase date,consumption date, inv. no. party name., item, qty. , values, etc. Now I need to create a Pivot table, in which it will look like this Month - Op. Bal. - Purchase - Consumption - Cl.Bal. I need to import the data from two separate sheets here and show report in one report. Thanks Regards, BS -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Excel2003_Style_Menu.xlam Description: Binary data
Re: $$Excel-Macros$$ Pivot Table (URGENT)
Hey thanks Priyanka, it workss perfectly the way I wanted to thanks alot :) On Fri, Jan 20, 2012 at 12:20 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Mahreen Kindly find the attached file and see the yellow highlighted row ,i have did the same w/o pivot On Thu, Jan 19, 2012 at 11:12 PM, Mahreen Ellahi mahreen.acc...@gmail.com wrote: Guys I have a range of data of which I want to plot a pivot table. My problem is that I have different expiry days but I want to club or group into certain buckets like 0 days,1- 30 days, 31-60 days etc. I dont want to take unexpired negative values in my pivot table. HELP NEEDED IN ATTACHED FILE. SAMPLE FORMAT ATTACHED BUT NOT AS A PIVOT TABLE. S # REGION BRANCH SEGMENT CUSTOMER NAME DATE OF APPROVAL ORIGINAL APPROVING AUTHORITY TOTAL FUNDED NON-FUNDED LIMIT (IN MILLION) DATE OF INTERIM REVIEW ANNUAL REVIEW DATE VALIDITY / EXPIRY Days Expired 1 SOUTH I KHI CORPORATEABC 07-Oct-2010 CC 50.000 31-Mar-2012 31-Mar-2012 (90) 2 SOUTH I KHI COMMERCIAL DEF 23-Dec-2010 CC 300.000 31-Dec-2011 31-Dec-2011 1 3 SOUTH I KHI COMMERCIAL SDS 02-Feb-2011 CC 682.940 29-Feb-2012 28-Feb-11 307 4 SOUTH I KHI CORPORATE FDFG 01-Nov-2010 CC 300.000 31-Mar-2012 31-Mar-2012 (90) 5 SOUTH I KHI CORPORATE DFG 02-May-2011 CC 1,200.000 31-Mar-2012 31-Mar-2011 276 6 SOUTH I KHI SME FDFG 25-Aug-2010 CC 375.000 31-Mar-2012 31-Mar-2012 (90) 7 SOUTH I KHI SME SDF 03-May-2011 CC 600.000 31-Mar-2012 31-Mar-2010 641 8 SOUTH I KHI SME SDF 27-Jun-2011 CC 620.000 30-Apr-2012 30-Apr-2012(120) 9 SOUTH I KHI CORPORATE DSF 22-Mar-2011 CC 210.000 30-Apr-2012 30-Sep-2011 93 10 SOUTH I KHI CORPORATE SDF 23-May-2011 CC 471.000 30-Apr-2012 30-Apr-2012 (120) 11 SOUTH I KHI COMMERCIAL SDF 10-May-2011 CC 800.000 30-Apr-2012 30-Apr-2012(120) 12 SOUTH I KHI CORPORATE SDF 23-May-2011 CC 1,300.000 31-Mar-2012 31-Mar-2012 (90) 13 SOUTH I KHI CORPORATE FDFG 13-Jul-2011 CC 1,300.000 31-Aug-2012 31-Aug-2011 123 14 SOUTH I KHI SME DFG 24-Jun-2010 CC 1,200.000 30-Sep-2011 30-Sep-2011 93 15 SOUTH I KHI CORPORATE DFG 18-Mar-2011 CC 400.000 31-Dec-2011 31-Dec-2011 1 16 SOUTH I KHI SME FDFGSD 02-Nov-2011 CC 300.000 31-Dec-2012 31-Jan-2009 1,065 17 SOUTH I KHI CORPORATE SDF 28-Mar-2011 CC 400.000 31-Mar-2012 31-Mar-2012 (90) 18 SOUTH I KHI COMMERCIAL SDF 23-Nov-2011 CC 900.000 31-Dec-2012 31-Dec-2012 (365) 19 SOUTH I KHI CORPORATE SDF 17-Jun-2011 CC 2,000.000 30-Apr-2012 30-May-2011 216 20 SOUTH I KHI COMMERCIAL SDF 28-Mar-2011 CC 1,700.000 30-Apr-2012 30-Apr-2012(120) -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or
Re: $$Excel-Macros$$ Pivot Table (URGENT)
You are welcome On Fri, Jan 20, 2012 at 2:23 PM, Mahreen Ellahi mahreen.acc...@gmail.comwrote: Hey thanks Priyanka, it workss perfectly the way I wanted to thanks alot :) On Fri, Jan 20, 2012 at 12:20 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Mahreen Kindly find the attached file and see the yellow highlighted row ,i have did the same w/o pivot On Thu, Jan 19, 2012 at 11:12 PM, Mahreen Ellahi mahreen.acc...@gmail.com wrote: Guys I have a range of data of which I want to plot a pivot table. My problem is that I have different expiry days but I want to club or group into certain buckets like 0 days,1- 30 days, 31-60 days etc. I dont want to take unexpired negative values in my pivot table. HELP NEEDED IN ATTACHED FILE. SAMPLE FORMAT ATTACHED BUT NOT AS A PIVOT TABLE. S # REGION BRANCH SEGMENT CUSTOMER NAME DATE OF APPROVAL ORIGINAL APPROVING AUTHORITY TOTAL FUNDED NON-FUNDED LIMIT (IN MILLION) DATE OF INTERIM REVIEW ANNUAL REVIEW DATE VALIDITY / EXPIRY Days Expired 1 SOUTH I KHI CORPORATEABC 07-Oct-2010 CC 50.000 31-Mar-2012 31-Mar-2012 (90) 2 SOUTH I KHI COMMERCIAL DEF 23-Dec-2010 CC 300.000 31-Dec-2011 31-Dec-2011 1 3 SOUTH I KHI COMMERCIAL SDS 02-Feb-2011 CC 682.940 29-Feb-2012 28-Feb-11 307 4 SOUTH I KHI CORPORATE FDFG 01-Nov-2010 CC 300.000 31-Mar-2012 31-Mar-2012 (90) 5 SOUTH I KHI CORPORATE DFG 02-May-2011 CC 1,200.000 31-Mar-2012 31-Mar-2011 276 6 SOUTH I KHI SME FDFG 25-Aug-2010 CC 375.000 31-Mar-2012 31-Mar-2012 (90) 7 SOUTH I KHI SME SDF 03-May-2011 CC 600.000 31-Mar-2012 31-Mar-2010 641 8 SOUTH I KHI SME SDF 27-Jun-2011 CC 620.000 30-Apr-2012 30-Apr-2012(120) 9 SOUTH I KHI CORPORATE DSF 22-Mar-2011 CC 210.000 30-Apr-2012 30-Sep-2011 93 10 SOUTH I KHI CORPORATE SDF 23-May-2011 CC 471.000 30-Apr-2012 30-Apr-2012(120) 11 SOUTH I KHI COMMERCIAL SDF 10-May-2011 CC 800.000 30-Apr-2012 30-Apr-2012(120) 12 SOUTH I KHI CORPORATE SDF 23-May-2011 CC 1,300.000 31-Mar-2012 31-Mar-2012 (90) 13 SOUTH I KHI CORPORATE FDFG 13-Jul-2011 CC 1,300.000 31-Aug-2012 31-Aug-2011 123 14 SOUTH I KHI SME DFG 24-Jun-2010 CC 1,200.000 30-Sep-2011 30-Sep-2011 93 15 SOUTH I KHI CORPORATE DFG 18-Mar-2011 CC 400.000 31-Dec-2011 31-Dec-2011 1 16 SOUTH I KHI SME FDFGSD 02-Nov-2011 CC 300.000 31-Dec-2012 31-Jan-2009 1,065 17 SOUTH I KHI CORPORATE SDF 28-Mar-2011 CC 400.000 31-Mar-2012 31-Mar-2012 (90) 18 SOUTH I KHI COMMERCIAL SDF 23-Nov-2011 CC 900.000 31-Dec-2012 31-Dec-2012(365) 19 SOUTH I KHI CORPORATE SDF 17-Jun-2011 CC 2,000.000 30-Apr-2012 30-May-2011 216 20 SOUTH I KHI COMMERCIAL SDF 28-Mar-2011 CC 1,700.000 30-Apr-2012 30-Apr-2012(120) -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions
Re: $$Excel-Macros$$ **Pivot Table Doubt**
Right Click on the pivot table, select Pivot Tabel Options, move to 'Data' tab and then Uncheck- Enable Show Details. For the date format i think its working fine in both rows n columns. On Thu, Sep 1, 2011 at 10:18 PM, Prabhu prabhugate...@gmail.com wrote: Hi Friends, I think topic got 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 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 data extract
Sorry.. just to reframe the question... I wanted all the details but not in Table format, because there I again need to convert the table to Range I want the information in normal format without any formatting. Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shaik Waheed Sent: Friday, September 02, 2011 04:54 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Pivot Table data extract Right Click on the pivot table, select Pivot Tabel Options, move to 'Data' tab and then Uncheck- Enable Show Details. On Fri, Sep 2, 2011 at 4:44 PM, Anil Bhange anil.bha...@tatacommunications.commailto:anil.bha...@tatacommunications.com wrote: Hi Expert, In Pivot table data details, when we double click on any value the details of those values extract from main database and another worksheet get prepared. In this process, new worksheet details (extracted one) by default extracted in Table Format and everytime we have to do Convert to Range Is there any shortcut where I don't get these details in Table format and will get in the normal data details. Anil Bhange Assistant Manager Financial Reporting Compliance, TATA Communications Ltd. VSB, Fort, Mumbai - 400 001, India ' Desk : + 91 22 6659 2320tel:%2B%2091%2022%206659%202320 | IP Phone : 51 2320 | Mobile :+ 91 90290 32123tel:%2B%2091%2090290%2032123 anil.bha...@tatacommunications.commailto:anil.bha...@tatacommunications.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ **Pivot Table Doubt**
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
Hi Anil copy below code in thisworkbook model Private Sub Workbook_NewSheet(ByVal Sh As Object) Dim sht As Worksheet Dim oLo As ListObject Set sht = ActiveSheet For Each oLo In sht.ListObjects sht.ListObjects(oLo.Name).TableStyle = Next End Sub Thanks Mahesh On Fri, Sep 2, 2011 at 6:02 PM, Shaik Waheed waheedb...@gmail.com wrote: Dear Anil. When u get the details in Table Format, Goto 'Design Tab-Table Styles--Select Clear.dats it. U dont have any other easier option than this Regards, Waheed On Fri, Sep 2, 2011 at 5:00 PM, Anil Bhange anil.bha...@tatacommunications.com wrote: Sorry.. just to reframe the question… ** ** I wanted all the details but not in “Table” format, because there I again need to convert the table to Range ** ** I want the information in normal format without any formatting. ** ** Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Shaik Waheed *Sent:* Friday, September 02, 2011 04:54 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Pivot Table data extract ** ** Right Click on the pivot table, select Pivot Tabel Options, move to 'Data' tab and then Uncheck- Enable Show Details. On Fri, Sep 2, 2011 at 4:44 PM, Anil Bhange anil.bha...@tatacommunications.com wrote: Hi Expert, In Pivot table data details, when we double click on any value the details of those values extract from main database and another worksheet get prepared. In this process, new worksheet details (extracted one) by default extracted in “Table Format” and everytime we have to do “Convert to Range” Is there any shortcut where I don’t get these details in Table format and will get in the normal data details. *Anil Bhange* *Assistant Manager* Financial Reporting Compliance, TATA Communications Ltd. VSB, Fort, Mumbai – 400 001, India ' Desk : + 91 22 6659 2320 | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 anil.bha...@tatacommunications.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel ** ** -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2
Re: $$Excel-Macros$$ **Pivot Table Doubt**
Hi, Right Click on the pivot table, select Pivot Tabel Options, move to 'Data' tab and then Uncheck- Enable Show Details. For the date format i think its working fine in both rows n columns. Regards, Waheed. On Thu, Sep 1, 2011 at 7:55 AM, Prabhu prabhugate...@gmail.com wrote: HI All, Plz find the pivot table sheet. kindly help. Regards, Prabhu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ **Pivot Table Doubt**
Plz put all ur queries n replies to the group id. So that everyone will try n learn, that is wht our objective. Thnx Waheed. On Thu, Sep 1, 2011 at 4:47 PM, John Alliage Tinio Morales alliage.mora...@gmail.com wrote: Thank you very much! Hope we could get in touch soon for future problems on Excel. Thank you! On Thu, Sep 1, 2011 at 5:44 PM, Shaik Waheed waheedb...@gmail.com wrote: Hi John, PFA, i have deleted some rows bcoz the file size was getting huge. What u need to do is take this as example and do it in ur original file, in sheet 2 u need to drag down the formulas till the end. Hope it hels u Regards, Waheed On Thu, Sep 1, 2011 at 1:59 PM, John Alliage Tinio Morales alliage.mora...@gmail.com wrote: I attach my raw file. GEOCODE contains the geographic code Other sheets contain the geographical areas without the codes On Thu, Sep 1, 2011 at 4:17 PM, Shaik Waheed waheedb...@gmail.com wrote: Can u plz mail a sample file. On Thu, Sep 1, 2011 at 1:08 PM, John Alliage Tinio Morales alliage.mora...@gmail.com wrote: If two geographical data match in two sheets, then add/copy/replicate unique id/code Hi guys, this is my problem. I have a geographical data (divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN, and BARANGAY/STREET) in one sheet. This sheet contains a UNIQUE GEOGRAPHICAL CODE that IS NUMERICAL IN NATURE. Now, I have also another sheet which lists the same geographical data (divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN, and BARANGAY/STREET). The geographic areas included in this sheet are recipients of one government program. But this sheet does not contain the UNIQUE GEOGRAPHICAL CODE. What I would like to do is to match the geographical data found in two sheets, and if they match, copy/replicate/add the UNIQUE GEOGRAPHICAL CODE found in sheet to the other sheet that does not contain the code. I would like to include the geographical code, so that it would become the primary key when I create a database in MS Access. This is the example SHEET 1 A B C D E 0019 REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET *Column A contains the UNIQUE GEOGRAPHICAL CODE SHEET 2 A B C D REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET *Sheet 2 contains only 20k entries of geographical areas while Sheet 1 contains about 40k entries. Only half of the geographical areas are included in the government program Can you help me? On Thu, Sep 1, 2011 at 3:11 PM, Shaik Waheed waheedb...@gmail.com wrote: Hi, Right Click on the pivot table, select Pivot Tabel Options, move to 'Data' tab and then Uncheck- Enable Show Details. For the date format i think its working fine in both rows n columns. Regards, Waheed. On Thu, Sep 1, 2011 at 7:55 AM, Prabhu prabhugate...@gmail.com wrote: HI All, Plz find the pivot table sheet. kindly help. Regards, Prabhu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- John Alliage Tinio Morales Researcher GMA News and Public Affairs Mobile: 0915.846.8473 Tel: (02) 982. loc 1338 Fax: (02) 982. loc 1340 DISCLAIMER: This Message may contain confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you received this message
Re: $$Excel-Macros$$ **Pivot Table Doubt**
*If two geographical data match in two sheets, then add/copy/replicate unique id/code* Hi guys, this is my problem. I have a geographical data (divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN, and BARANGAY/STREET) in one sheet. This sheet contains a UNIQUE GEOGRAPHICAL CODE that IS NUMERICAL IN NATURE. Now, I have also another sheet which lists the same geographical data (divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN, and BARANGAY/STREET). The geographic areas included in this sheet are recipients of one government program. But this sheet does not contain the UNIQUE GEOGRAPHICAL CODE. What I would like to do is to match the geographical data found in two sheets, and if they match, copy/replicate/add the UNIQUE GEOGRAPHICAL CODE found in sheet to the other sheet that does not contain the code. I would like to include the geographical code, so that it would become the primary key when I create a database in MS Access. This is the example SHEET 1 A B C D E 0019 REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET *Column A contains the UNIQUE GEOGRAPHICAL CODE SHEET 2 A B C D REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET *Sheet 2 contains only 20k entries of geographical areas while Sheet 1 contains about 40k entries. Only half of the geographical areas are included in the government program Can you help me? On Thu, Sep 1, 2011 at 3:11 PM, Shaik Waheed waheedb...@gmail.com wrote: Hi, Right Click on the pivot table, select Pivot Tabel Options, move to 'Data' tab and then Uncheck- Enable Show Details. For the date format i think its working fine in both rows n columns. Regards, Waheed. On Thu, Sep 1, 2011 at 7:55 AM, Prabhu prabhugate...@gmail.com wrote: HI All, Plz find the pivot table sheet. kindly help. Regards, Prabhu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *John Alliage Tinio Morales* *Researcher** GMA News and Public Affairs* Mobile: 0915.846.8473 Tel: (02) 982. loc 1338 Fax: (02) 982. loc 1340 DISCLAIMER: This Message may contain confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you received this message in error please notify your Mail Administrator and delete this message immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of GMA Network, Inc. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ **Pivot Table Doubt**
Sir, I totally confused to put my query in group ID. pls tell me the procedure On Thu, Sep 1, 2011 at 5:58 PM, Shaik Waheed waheedb...@gmail.com wrote: Plz put all ur queries n replies to the group id. So that everyone will try n learn, that is wht our objective. Thnx Waheed. On Thu, Sep 1, 2011 at 4:47 PM, John Alliage Tinio Morales alliage.mora...@gmail.com wrote: Thank you very much! Hope we could get in touch soon for future problems on Excel. Thank you! On Thu, Sep 1, 2011 at 5:44 PM, Shaik Waheed waheedb...@gmail.com wrote: Hi John, PFA, i have deleted some rows bcoz the file size was getting huge. What u need to do is take this as example and do it in ur original file, in sheet 2 u need to drag down the formulas till the end. Hope it hels u Regards, Waheed On Thu, Sep 1, 2011 at 1:59 PM, John Alliage Tinio Morales alliage.mora...@gmail.com wrote: I attach my raw file. GEOCODE contains the geographic code Other sheets contain the geographical areas without the codes On Thu, Sep 1, 2011 at 4:17 PM, Shaik Waheed waheedb...@gmail.com wrote: Can u plz mail a sample file. On Thu, Sep 1, 2011 at 1:08 PM, John Alliage Tinio Morales alliage.mora...@gmail.com wrote: If two geographical data match in two sheets, then add/copy/replicate unique id/code Hi guys, this is my problem. I have a geographical data (divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN, and BARANGAY/STREET) in one sheet. This sheet contains a UNIQUE GEOGRAPHICAL CODE that IS NUMERICAL IN NATURE. Now, I have also another sheet which lists the same geographical data (divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN, and BARANGAY/STREET). The geographic areas included in this sheet are recipients of one government program. But this sheet does not contain the UNIQUE GEOGRAPHICAL CODE. What I would like to do is to match the geographical data found in two sheets, and if they match, copy/replicate/add the UNIQUE GEOGRAPHICAL CODE found in sheet to the other sheet that does not contain the code. I would like to include the geographical code, so that it would become the primary key when I create a database in MS Access. This is the example SHEET 1 A B C D E 0019 REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET *Column A contains the UNIQUE GEOGRAPHICAL CODE SHEET 2 A B C D REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET *Sheet 2 contains only 20k entries of geographical areas while Sheet 1 contains about 40k entries. Only half of the geographical areas are included in the government program Can you help me? On Thu, Sep 1, 2011 at 3:11 PM, Shaik Waheed waheedb...@gmail.com wrote: Hi, Right Click on the pivot table, select Pivot Tabel Options, move to 'Data' tab and then Uncheck- Enable Show Details. For the date format i think its working fine in both rows n columns. Regards, Waheed. On Thu, Sep 1, 2011 at 7:55 AM, Prabhu prabhugate...@gmail.com wrote: HI All, Plz find the pivot table sheet. kindly help. Regards, Prabhu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- John Alliage Tinio Morales Researcher GMA News and Public Affairs Mobile: 0915.846.8473 Tel: (02) 982. loc 1338 Fax: (02) 982. loc 1340 DISCLAIMER:
Re: $$Excel-Macros$$ **Pivot Table Doubt**
Hi, Write the correct problem in subject section, like pivot, conditional formatting, lookup function,. and then elaborate the problem as clearly as u can, and also if possible attach the sample sheet. Regards, Waheed. On Thu, Sep 1, 2011 at 7:26 PM, Shankar Bheema shankar.n...@gmail.com wrote: Sir, I totally confused to put my query in group ID. pls tell me the procedure On Thu, Sep 1, 2011 at 5:58 PM, Shaik Waheed waheedb...@gmail.com wrote: Plz put all ur queries n replies to the group id. So that everyone will try n learn, that is wht our objective. Thnx Waheed. On Thu, Sep 1, 2011 at 4:47 PM, John Alliage Tinio Morales alliage.mora...@gmail.com wrote: Thank you very much! Hope we could get in touch soon for future problems on Excel. Thank you! On Thu, Sep 1, 2011 at 5:44 PM, Shaik Waheed waheedb...@gmail.com wrote: Hi John, PFA, i have deleted some rows bcoz the file size was getting huge. What u need to do is take this as example and do it in ur original file, in sheet 2 u need to drag down the formulas till the end. Hope it hels u Regards, Waheed On Thu, Sep 1, 2011 at 1:59 PM, John Alliage Tinio Morales alliage.mora...@gmail.com wrote: I attach my raw file. GEOCODE contains the geographic code Other sheets contain the geographical areas without the codes On Thu, Sep 1, 2011 at 4:17 PM, Shaik Waheed waheedb...@gmail.com wrote: Can u plz mail a sample file. On Thu, Sep 1, 2011 at 1:08 PM, John Alliage Tinio Morales alliage.mora...@gmail.com wrote: If two geographical data match in two sheets, then add/copy/replicate unique id/code Hi guys, this is my problem. I have a geographical data (divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN, and BARANGAY/STREET) in one sheet. This sheet contains a UNIQUE GEOGRAPHICAL CODE that IS NUMERICAL IN NATURE. Now, I have also another sheet which lists the same geographical data (divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN, and BARANGAY/STREET). The geographic areas included in this sheet are recipients of one government program. But this sheet does not contain the UNIQUE GEOGRAPHICAL CODE. What I would like to do is to match the geographical data found in two sheets, and if they match, copy/replicate/add the UNIQUE GEOGRAPHICAL CODE found in sheet to the other sheet that does not contain the code. I would like to include the geographical code, so that it would become the primary key when I create a database in MS Access. This is the example SHEET 1 A B C D E 0019 REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET *Column A contains the UNIQUE GEOGRAPHICAL CODE SHEET 2 A B C D REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET *Sheet 2 contains only 20k entries of geographical areas while Sheet 1 contains about 40k entries. Only half of the geographical areas are included in the government program Can you help me? On Thu, Sep 1, 2011 at 3:11 PM, Shaik Waheed waheedb...@gmail.com wrote: Hi, Right Click on the pivot table, select Pivot Tabel Options, move to 'Data' tab and then Uncheck- Enable Show Details. For the date format i think its working fine in both rows n columns. Regards, Waheed. On Thu, Sep 1, 2011 at 7:55 AM, Prabhu prabhugate...@gmail.com wrote: HI All, Plz find the pivot table sheet. kindly help. Regards, Prabhu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to
Re: $$Excel-Macros$$ **Pivot Table Doubt**
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**
Can you post the pivoted file plz ? Thanks Prasad Sent from BlackBerry® on Airtel -Original Message- From: Prabhu prabhugate...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 31 Aug 2011 12:28:10 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ **Pivot Table Doubt** Hi Friends, When i double click my Pivot table value a new sheet is appearing with the details. But all the amount columns are showing in date format. Can anybody help how to rectify the same.(value should show in Number format and date should be in date format) Plz help. Regards, Prabhu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ **Pivot Table Doubt**
Hi Prabhu, Send send some sample data with pivot... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Wed, Aug 31, 2011 at 12:28 PM, Prabhu prabhugate...@gmail.com wrote: Hi Friends, When i double click my Pivot table value a new sheet is appearing with the details. But all the amount columns are showing in date format. Can anybody help how to rectify the same.(value should show in Number format and date should be in date format) Plz help. Regards, Prabhu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ **Pivot Table Doubt**
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 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
RE: $$Excel-Macros$$ Pivot table to remain intact - even if data table is removed
That's true... but what if I wants to refresh the Pivot table with new data? Best Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Monday, August 29, 2011 2:02 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Pivot table to remain intact - even if data table is removed Pivot table has a cache Memory which holds all the data of Data Table if data table is removed , Pivot table can not be refreshed. but you can get all data from Pivot table, it means Data Stored in Pivot table will not effect if Data Table is Removed .. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Amit Desai (MERU) Sent: Monday, August 29, 2011 1:13 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Pivot table to remain intact - even if data table is removed Dear Friend, I am preparing an MIS however to compare the result of MIS I am also preparing few Pivot table. I want to keep the Pivot table selected field intact even if the sheet in the data table is removed. Is that possible? Best Regards, Amit Desai Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Pivot table to remain intact - even if data table is removed
then ..press Alt + D +P +B and select new range ... On Mon, Aug 29, 2011 at 2:59 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: That’s true… but what if I wants to refresh the Pivot table with new data? ** ** Best Regards, Amit Desai ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Rajan_Verma *Sent:* Monday, August 29, 2011 2:02 PM *To:* excel-macros@googlegroups.com *Subject:* RE: $$Excel-Macros$$ Pivot table to remain intact - even if data table is removed ** ** *Pivot table has a cache Memory which holds all the data of Data Table if data table is removed , Pivot table can not be refreshed. but you can get all data from Pivot table, it means Data Stored in Pivot table will not effect if Data Table is Removed ..* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Amit Desai (MERU) *Sent:* Monday, August 29, 2011 1:13 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Pivot table to remain intact - even if data table is removed ** ** Dear Friend, ** ** I am preparing an MIS however to compare the result of MIS I am also preparing few Pivot table. ** ** I want to keep the Pivot table selected field intact even if the sheet in the data table is removed. Is that possible? ** ** Best Regards, Amit Desai ** ** ** ** ** ** -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel
RE: $$Excel-Macros$$ Pivot Table Percent of Column...
Have a look at the page : http://support.microsoft.com/kb/106359/en-us Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Robert Jacobs Envoyé : jeudi 25 août 2011 16:35 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ Pivot Table Percent of Column... Thanks in advance experts!!! This is very complicated to explain, but I'll give it a go: I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3 Sales), and need to find the percent of sales for each category, for each year in my data. For instance, if I have: Invoice#YearCat1Cat2Cat3 123456 2006$5.00 $4.00 $3.00 234567 2006$5.00 $4.00 $3.00 345678 2006$5.00 $4.00 $3.00 987654 2007$3.00 $4.00 $5.00 876543 2007$3.00 $4.00 $5.00 765432 2007$3.00 $4.00 $5.00 I need a pivot table that will sum all values for each category by year, then tell me what percent of that year's sales belonged to that category. I can get a pivot table to show each category by year with total sales like this: Values2006 2007 Cat1 $15.00 $9.00 Cat2 $12.00 $12.00 Cat3 $9.00 $15.00 BUT, I really need the percent of each category for that column. For instance, 2006 and 2007 both have $36.00 total sales. So I would want to know what percent of that $36.00 was for Cat1, Cat2, and Cat3. Something like this: Values20062007 Cat1 42% 25% Cat2 33% 33% Cat3 25% 42% Does anybody have any recommendations? I have tried Show Value As Percent of Column, but it always shows 100%. If I Show Value As Percent of Row, it shows what percentage of the total sales of Cat1 was sold for each year. i.e. - Cat1 would show 62% for 2006 and 38% for 2007. Any help would be GREATLY appreciated!!! Thank you! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Pivot Table Percent of Column...
Hi please find the attachment it may help -- *Great day,* *viper * On Fri, Aug 26, 2011 at 2:13 PM, Daniel dcolarde...@free.fr wrote: Have a look at the page : http://support.microsoft.com/kb/106359/en-us Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Robert Jacobs Envoyé : jeudi 25 août 2011 16:35 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ Pivot Table Percent of Column... Thanks in advance experts!!! This is very complicated to explain, but I'll give it a go: I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3 Sales), and need to find the percent of sales for each category, for each year in my data. For instance, if I have: Invoice#YearCat1Cat2Cat3 123456 2006$5.00 $4.00 $3.00 234567 2006$5.00 $4.00 $3.00 345678 2006$5.00 $4.00 $3.00 987654 2007$3.00 $4.00 $5.00 876543 2007$3.00 $4.00 $5.00 765432 2007$3.00 $4.00 $5.00 I need a pivot table that will sum all values for each category by year, then tell me what percent of that year's sales belonged to that category. I can get a pivot table to show each category by year with total sales like this: Values2006 2007 Cat1 $15.00 $9.00 Cat2 $12.00 $12.00 Cat3 $9.00 $15.00 BUT, I really need the percent of each category for that column. For instance, 2006 and 2007 both have $36.00 total sales. So I would want to know what percent of that $36.00 was for Cat1, Cat2, and Cat3. Something like this: Values20062007 Cat1 42% 25% Cat2 33% 33% Cat3 25% 42% Does anybody have any recommendations? I have tried Show Value As Percent of Column, but it always shows 100%. If I Show Value As Percent of Row, it shows what percentage of the total sales of Cat1 was sold for each year. i.e. - Cat1 would show 62% for 2006 and 38% for 2007. Any help would be GREATLY appreciated!!! Thank you! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel sample.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Pivot Table Percent of Column...
Thanks to everybody for their suggestions. Fred - I couldn't layout my data the way you suggested, just due to the sheer number of rows it would have created. The data I provided was a joke compared to what is actually listed, and the number of categories is much, much more than the 3 I gave in my example. But I did keep your example in my resources for 'just in case' future spreadsheets. Daniel - I had found that page a while ago. As I mentioned in my post, it wasn't calculating the percent of the column that I wanted - it always gave me 100%. Thanks for the reply though. Viper - It took me a little digging (because your sample was EXACTLY what I needed) before I figured out how you accomplished what you accomplished. I did, however, figure it out, and it your methods work perfectly for what I needed. 5000 points to you, and thank you very much for your help. All of your suggestions are appreciated. Thank you for serving us little guys. You're awesome! On Aug 26, 6:31 am, §»VIPER«§ viper@gmail.com wrote: Hi please find the attachment it may help -- *Great day,* *viper * On Fri, Aug 26, 2011 at 2:13 PM, Daniel dcolarde...@free.fr wrote: Have a look at the page : http://support.microsoft.com/kb/106359/en-us Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Robert Jacobs Envoyé : jeudi 25 août 2011 16:35 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ Pivot Table Percent of Column... Thanks in advance experts!!! This is very complicated to explain, but I'll give it a go: I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3 Sales), and need to find the percent of sales for each category, for each year in my data. For instance, if I have: Invoice# Year Cat1 Cat2 Cat3 123456 2006 $5.00 $4.00 $3.00 234567 2006 $5.00 $4.00 $3.00 345678 2006 $5.00 $4.00 $3.00 987654 2007 $3.00 $4.00 $5.00 876543 2007 $3.00 $4.00 $5.00 765432 2007 $3.00 $4.00 $5.00 I need a pivot table that will sum all values for each category by year, then tell me what percent of that year's sales belonged to that category. I can get a pivot table to show each category by year with total sales like this: Values 2006 2007 Cat1 $15.00 $9.00 Cat2 $12.00 $12.00 Cat3 $9.00 $15.00 BUT, I really need the percent of each category for that column. For instance, 2006 and 2007 both have $36.00 total sales. So I would want to know what percent of that $36.00 was for Cat1, Cat2, and Cat3. Something like this: Values 2006 2007 Cat1 42% 25% Cat2 33% 33% Cat3 25% 42% Does anybody have any recommendations? I have tried Show Value As Percent of Column, but it always shows 100%. If I Show Value As Percent of Row, it shows what percentage of the total sales of Cat1 was sold for each year. i.e. - Cat1 would show 62% for 2006 and 38% for 2007. Any help would be GREATLY appreciated!!! Thank you! -- --- - -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- --- --- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel sample.xls 14KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at
Re: $$Excel-Macros$$ Pivot Table Percent of Column...
try formula please find attachment... On Thu, Aug 25, 2011 at 8:04 PM, Robert Jacobs robertjacob...@gmail.comwrote: Thanks in advance experts!!! This is very complicated to explain, but I'll give it a go: I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3 Sales), and 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 - show pages as individual workbooks
Please attached the sheet or file we could help u then On Thu, Jun 30, 2011 at 9:50 PM, crossy75 sjc5...@yahoo.co.uk wrote: Hello again - and thanks for the last response, you guys are ace! right have now taken a lot of data relating to clients and have a pivot table, which when i show pages lists 30 worksheets with each one being a separate client and valuation. Is there a way instead of showing the pages as individual worksheets, as individual workbooks with the file name saved as which would be the tab name if you clicked on the 'show pages.' (ie from tab 'smith' tab 'jones' to a file smith.xls with one tab ''smith' and another file 'jones.xls with one tab 'Jones') I think this might be a 3 stage process in shoing pages, then doing a loop to move the first sheet to a new workbook then saving it as the tab name closing the file then looping to do the same again till no more sheets are left in the main workbook if there is a smarter way please let me know. ta Simon -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Pivot table - Pivot tabel row Range
Could you tell me what have you done ??? On Sun, Apr 3, 2011 at 8:42 PM, Jaideep Panchal jai.ca...@gmail.com wrote: if it helps... -- Rakesh kumar khowal +91 9868532105 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Pivot table - Pivot tabel row Range
Hi Umesh/Group members, I am attaching the sample data. I know if I take gender for column it'll solve the problem, but for some reason I don't wish to add any field in the column.. Thanks ! On Fri, Apr 1, 2011 at 7:07 PM, Umesh Dev umesh.d...@gmail.com wrote: Hi Rakesh, can you attach the excel sheet Regards Umesh Dev On Fri, Apr 1, 2011 at 4:29 PM, rakesh kumar rakeshshail2...@gmail.comwrote: Hi ! Group members, I have a pivot table, which shows 5 income groups in row Range and their counts. However, when I apply a filter it leaves 3 income groups in the row range as other two groups don't match the filter criteria. I want the pivot table to keep all five groups and if a group doesn't match the filter criteria it should show 0 or anything else will just do. any idea ??? Thanks !! -- Rakesh kumar khowal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Rakesh kumar khowal +91 9868532105 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel test_x.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Pivot table - Pivot tabel row Range
Hi Rakesh, See if it helps... Regards, Jaideep Panchal New Delhi - Original Message - From: rakesh kumar To: excel-macros@googlegroups.com Sent: Sunday, April 03, 2011 1:44 PM Subject: Re: $$Excel-Macros$$ Pivot table - Pivot tabel row Range Hi Umesh/Group members, I am attaching the sample data. I know if I take gender for column it'll solve the problem, but for some reason I don't wish to add any field in the column.. Thanks ! On Fri, Apr 1, 2011 at 7:07 PM, Umesh Dev umesh.d...@gmail.com wrote: Hi Rakesh, can you attach the excel sheet Regards Umesh Dev On Fri, Apr 1, 2011 at 4:29 PM, rakesh kumar rakeshshail2...@gmail.com wrote: Hi ! Group members, I have a pivot table, which shows 5 income groups in row Range and their counts. However, when I apply a filter it leaves 3 income groups in the row range as other two groups don't match the filter criteria. I want the pivot table to keep all five groups and if a group doesn't match the filter criteria it should show 0 or anything else will just do. any idea ??? Thanks !! -- Rakesh kumar khowal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Rakesh kumar khowal +91 9868532105 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel test_x.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Pivot table - Pivot tabel row Range
Hi Rakesh, can you attach the excel sheet Regards Umesh Dev On Fri, Apr 1, 2011 at 4:29 PM, rakesh kumar rakeshshail2...@gmail.comwrote: Hi ! Group members, I have a pivot table, which shows 5 income groups in row Range and their counts. However, when I apply a filter it leaves 3 income groups in the row range as other two groups don't match the filter criteria. I want the pivot table to keep all five groups and if a group doesn't match the filter criteria it should show 0 or anything else will just do. any idea ??? Thanks !! -- Rakesh kumar khowal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Pivot Table Help
Thank you Ashish and Viswanathan very much. Problem solved. John On Sun, Mar 27, 2011 at 2:28 AM, ashish koul koul.ash...@gmail.com wrote: check the attachment see if it helps On Sun, Mar 27, 2011 at 11:18 AM, ashish koul koul.ash...@gmail.comwrote: On Sun, Mar 27, 2011 at 5:51 AM, Viswanathan M vis...@gmail.com wrote: Dear Mr. John, =SUM(NOT(B2=),NOT(D2=),NOT(F2=)) The above formula will help you for finding out the Total Deliveries *With warm regards* *Viswanathan M* DE(Tech) RGM TTC Chennai-600027 *Vande* *Mataram* On Sat, Mar 26, 2011 at 9:57 PM, John A. Smith johnasmit...@gmail.comwrote: I have an excel database where each line represents an entity and it's data over about 70 columns. There are multiple occurrences of delivery information in these columns that I need to summarize in a pivot table. Some lines may have only one occurrence of this delivery while some others may have three or four. Please see my example attached. Thank you for your continuing help. John -- -- 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 -- *With warm regards* *Viswanathan M* DE(Tech) RGM TTC Chennai-600027 *Vande* *Mataram* -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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 Help
Dear Mr. John, =SUM(NOT(B2=),NOT(D2=),NOT(F2=)) The above formula will help you for finding out the Total Deliveries *With warm regards* *Viswanathan M* DE(Tech) RGM TTC Chennai-600027 *Vande* *Mataram* On Sat, Mar 26, 2011 at 9:57 PM, John A. Smith johnasmit...@gmail.comwrote: I have an excel database where each line represents an entity and it's data over about 70 columns. There are multiple occurrences of delivery information in these columns that I need to summarize in a pivot table. Some lines may have only one occurrence of this delivery while some others may have three or four. Please see my example attached. Thank you for your continuing help. John -- -- 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 -- *With warm regards* *Viswanathan M* DE(Tech) RGM TTC Chennai-600027 *Vande* *Mataram* -- -- 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 problem
Thanks!!! Anil, Its working great!! Regards, Deepak On Tue, Feb 1, 2011 at 11:58 AM, Anil Bhange anil.bha...@tatacommunications.com wrote: Hi Deepak, Please find the reply to your queries. Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Deepak Rawat *Sent:* Tuesday, February 01, 2011 11:11 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Pivot table problem Hi All I have a problem in fetching the data from the raw data, pls suggest the best way. Problem file is attached. There are two worksheets, 1st one is Raw Data 2nd one is Required data. Regards, Deepak -- -- 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 problem
Hi Deepak, Please find the reply to your queries. Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Deepak Rawat Sent: Tuesday, February 01, 2011 11:11 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Pivot table problem Hi All I have a problem in fetching the data from the raw data, pls suggest the best way. Problem file is attached. There are two worksheets, 1st one is Raw Data 2nd one is Required data. Regards, Deepak -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Copy of Problem.xlsx Description: Copy of Problem.xlsx
Re: $$Excel-Macros$$ Pivot table problem
Hi Deepak Rawat, You can create a calculated pivot field. it´s possible by accessing Options tab (when selected a pivot table cell) and click on formulas button. I´ve created the formula in the attached file. Regards, FLemos. 2010/8/7 Deepak Rawat deepakexce...@gmail.com Hi all I have attached a file containg pivot table with some data. I have two qurries 1. I want to put a foruma next to pivot table and want to copy and paste all formula to all rows but its taking freezing cells by default. If data quatity is high than how could i put the formula in all cells. 2. if i able to put formula in all cells then when i click on plus sign and open it i.e. if i click on Arind then when it open all cells in Arind the formula got the error #REF! how could i make the formula to sick there. Regards, Deepak Rawat -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Fabio Lemos e-mail: flnle...@gmail.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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Pivot table problem.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Pivot table problem Pls help me
Hi Venkatesh, Please right click on Pivot Table Cilcik On Pivot Table Options Then Cilck on display Cick On Classic Pivot Table layout Ok Thanks Regards Anil Kumar On Tue, Jul 27, 2010 at 6:32 PM, Venkatesh Narla nvenki...@gmail.comwrote: Dear All, I have problem in 2007 Excel Pivot table Pls find the Pictures. Best Regards, Venkatesh narla, 9886058917 -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Pivot table problem Pls help me
hey venkatesh, both are one and the same wt is your excat problam in that. Can u please eleabrate? or give me the sample file. On 7/27/10, Venkatesh Narla nvenki...@gmail.com wrote: Dear All, I have problem in 2007 Excel Pivot table Pls find the Pictures. Best Regards, Venkatesh narla, 9886058917 -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Regards, Dileep Kumar Kaza Duty is God Work is Worship -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Pivot table problem Pls help me
Thanks a Lot I have done that.. On Tue, Jul 27, 2010 at 6:32 PM, Venkatesh Narla nvenki...@gmail.com wrote: Dear All, I have problem in 2007 Excel Pivot table Pls find the Pictures. Best Regards, Venkatesh narla, 9886058917 -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Pivot table not showing
Hi Friends Thanx for ur kind reply. Deepak On Fri, Jun 18, 2010 at 8:45 AM, Vijay Aggarwal vjaggarwal2...@gmail.comwrote: hi Deepak, This file has been shared. Please remove sharing (tools--share workbook) and then Pivot will start working. regards, Vijay On Wed, Jun 16, 2010 at 10:59 PM, Deepak Rawat deepakexce...@gmail.comwrote: Hi friends, I got an excel file, in which pivot table option is disable and not working. But i am unable to find the reason of the same. If anybody can find then pls reply. Regards, Deepak -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Pivot table not showing
hi Deepak, This file has been shared. Please remove sharing (tools--share workbook) and then Pivot will start working. regards, Vijay On Wed, Jun 16, 2010 at 10:59 PM, Deepak Rawat deepakexce...@gmail.comwrote: Hi friends, I got an excel file, in which pivot table option is disable and not working. But i am unable to find the reason of the same. If anybody can find then pls reply. Regards, Deepak -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Pivot table not showing
Hi, This file is shared. you will have to remove this.. Go to Tools- share work book- uncheck the ' allow changes' - ok Regards, Mathan On Thu, Jun 17, 2010 at 11:29 AM, Deepak Rawat deepakexce...@gmail.comwrote: Hi friends, I got an excel file, in which pivot table option is disable and not working. But i am unable to find the reason of the same. If anybody can find then pls reply. Regards, Deepak -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Pivot table for Datewise Bank Balance
good On Wed, Jun 2, 2010 at 4:52 PM, prabhakar thakur prabhakarthak...@gmail.com wrote: Dear, Please find the attached your query. Thanks, Prabhakar Thakur New Delhi +919953736776 On Wed, Jun 2, 2010 at 12:37 PM, Ashish Khandelwal 4everash...@gmail.comwrote: Dear friends, I want to create a Pivot table with the attached data file. In that I want to check the Bank Balnce datewise or Bank wise. Please send me the Pivot table for the same which will solve my requirement. Pl shelp me in this regard. Thanks, Ashish. -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Pivot Table Help - Gross Margin % % of Sales
Guru, I actually want to see both of those line items as percentages of sales which is to say, take gross margin $ and divide it by sales. Same for operating income. Thanks! -- -- Some important links for excel 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Pivot Table Help - Gross Margin % % of Sales
here you go http://www.mediafire.com/download.php?nvt1ymtzjdy thanks for your help! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Pivot Table Help - Gross Margin % % of Sales
Hi, Just see the attached file and confirm If this is what you are looking for. Best Regards, Guru On Tue, May 4, 2010 at 8:57 PM, dza7 dvpe...@gmail.com wrote: Hello, I have a challenging pivot table issue that I hope I can get some help on. Here is the spreadsheet I'm working with: https://www.yousendit.com/download/OHo0N3RSSU90d0UwTVE9PQ I'm having problems with showing percentages in my pivot table such as gross margin and operational profit. Here is the PL pivot table as I have it now, as you can see I can't get the Gross Margin % to output a number. Both Gross Margin % and Operational Profit % are calculated fields I've added to the pivot table since the raw data only includes sales, cost of goods sold expenses. I believe that this has something to do with the detail that I want to show in different parts of the PL. With that in mind I've attempted to add new fields to the data to help but still no success. I can add as much as it is needed to the data to make this work (outside of changing the first column and the PTD, QTD YTD figures which are output from our system) but I'm at a standstill. Can someone help!?! I have to roll this out amongst different divisions and it's going to be a killer tool if I can figure it out! Thanks in advance. Dvpetta Dza -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe COMPARISON Pamp;L.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Pivot Table Help - Gross Margin % % of Sales
Dvpetta, Can you upload a 2003 version, i may be able to give a thought on it CC me in, so that i know that you have uploaded the sheet Cheers Harry On May 4, 8:27 pm, dza7 dvpe...@gmail.com wrote: Hello, I have a challenging pivot table issue that I hope I can get some help on. Here is the spreadsheet I'm working with:https://www.yousendit.com/download/OHo0N3RSSU90d0UwTVE9PQ I'm having problems with showing percentages in my pivot table such as gross margin and operational profit. Here is the PL pivot table as I have it now, as you can see I can't get the Gross Margin % to output a number. Both Gross Margin % and Operational Profit % are calculated fields I've added to the pivot table since the raw data only includes sales, cost of goods sold expenses. I believe that this has something to do with the detail that I want to show in different parts of the PL. With that in mind I've attempted to add new fields to the data to help but still no success. I can add as much as it is needed to the data to make this work (outside of changing the first column and the PTD, QTD YTD figures which are output from our system) but I'm at a standstill. Can someone help!?! I have to roll this out amongst different divisions and it's going to be a killer tool if I can figure it out! Thanks in advance. Dvpetta Dza -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Pivot Table - Prevent to add/remove fields except page field
Hi Cecilia, Try the solution attached with this email. You need to apply the protection to the spreadsheet and just need to check the checkboxes as shown in the solution. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Tue, Apr 13, 2010 at 6:30 PM, Cecilia Chiderski cecic...@hotmail.comwrote: Hi, I have a sheet with three Pivot Tables. I want to allow the user to select any value on the Page fields, but I don't want the user to: - Add more page fields - Remove the existing page fields - Add/remove any other field in the Pivot Is there any way to prevent the user to do it?? Thanks, Cecilia -- ¿Sabes cómo tener tus amigos de Facebook en Messenger? Entra aquíhttp://profile.live.com/connect -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. attachment: Pivot-Protect by DiLipandey.png
RE: $$Excel-Macros$$ Pivot Table - Prevent to add/remove fields except page field
Hi Dilip! Thanks for your suggestion, but it is not working as expected... If I protect in that way, then the user can not drill into the details anymore. I want the user to drill, to change page fields, but prevent to add/remove fields in the columns/rows Date: Thu, 15 Apr 2010 16:45:03 +0530 Subject: Re: $$Excel-Macros$$ Pivot Table - Prevent to add/remove fields except page field From: dilipan...@gmail.com To: excel-macros@googlegroups.com CC: cecic...@hotmail.com Hi Cecilia, Try the solution attached with this email. You need to apply the protection to the spreadsheet and just need to check the checkboxes as shown in the solution. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Tue, Apr 13, 2010 at 6:30 PM, Cecilia Chiderski cecic...@hotmail.com wrote: Hi, I have a sheet with three Pivot Tables. I want to allow the user to select any value on the Page fields, but I don't want the user to: - Add more page fields - Remove the existing page fields - Add/remove any other field in the Pivot Is there any way to prevent the user to do it?? Thanks, Cecilia ¿Sabes cómo tener tus amigos de Facebook en Messenger? Entra aquí -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _ Recibe un SMS de tu Hotmail vayas donde vayas. ¡Date de alta! http://home.mobile.live.com/MobileAttach.mvc/?mkt=es-es -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ pivot table help for pos
Hello Dear, I have already viewed your problem. please respond that what you want in pivot column and in pivot row. Please reply so that we can prepare exact pivot. Hope It Will Help Happy To Help :) Shyam On Fri, Mar 12, 2010 at 5:25 PM, satya narayana snarayana@gmail.comwrote: -- Forwarded message -- From: satya narayana snarayana@gmail.com Date: Fri, Mar 12, 2010 at 5:24 PM Subject: pivot table help for pos To: dilipan...@gmail.com *To * *Dear Friends,* *I have a huge data pertaining different sites ,pos,partys, ele items,quantities* *I want to see the report in pivot table like site wise,partywise,powise,item wise,and monthwise,po balance,and value.* *Could u help me in this regard. And if there is any other suggestions please advise me* *Please find the attached exel file containing data.* * * *Thanking you* *Yours truly,* *satya* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Pivot table output to pdf with multiple page fields
Dear TheoMa, one suggestion here:- Install Adobe Acrobat professional and then you can convert the each page output as PDF in a single click. Let me know if other information is required on this line. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 1/30/10, TheoMa theodore_douca...@hotmail.com wrote: Hi, I have a pivot table with 3 page fields, PageF1, PageF2 and PageF3 Each has a number of values including (All) I want to go through every combination of the pagefields and if the pivot table has actual values in the data region to output to a pdf file with a filename format: Pagef1 - PageF2 - PageF3 .pdf The code goes through each page combination, but I cant exclude page fields with (all) i cant capture the names of the page fields of the combinations that have data in the data body range in a filename and use that filename to output the pivottable I am using the following code that i found at http://www.contextures.com/xlPivot09.html Your help is welcomed Sub PrintPivotPages() 'prints a copy of pivot table for 'each item in page field On Error Resume Next Dim pt As PivotTable Dim File As Variant 'somehow this would be used to define the filename need Dim pf As PivotField Dim pi As PivotItem Dim RngToSum As Range Set pt = ActiveSheet.PivotTables.Item(1) Set RngToSum = Nothing For Each pf In pt.PageFields For Each pi In pf.PivotItems pt.PivotFields(pf.Name).CurrentPage = pi.Name 'this is the data range of the pivottable Set RngToSum = pt.DataBodyRange If Application.WorksheetFunction.Sum(RngToSum) 0 Then ActiveSheet.PrintPreview 'use this for testing 'Specify acrobat file name and type 'This portion does not work, need help: Set File = pi.value.pdf 'ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= File, _ 'Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _ ':=False, OpenAfterPublish:=True End If Next Next pf End Sub -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ PIVOT TABLE AND PERCENTAGE
Hi Skanda, Attached please find the solution..Lemme know if the format is according to your requirements.. Cheers!! ANISH On Wed, Dec 16, 2009 at 8:46 PM, Skanda skanda.pokkun...@gmail.com wrote: Srini, Thanks for the response.Let me explain my requirement. We need the percentage at the physician level. say for instance, Srini has total qty 30. so the BCBS for srini is 10/30 which is 0.33% and wellcare for srini is 20/30 which is 0.66%. we should not combine samuel total with srini total to get the percentage at phy level. and could you if you can..explain to me in steps how to get the pivot table if you have a solution. Skanda. On Wed, Dec 16, 2009 at 3:13 AM, Srinivasulu Reddy Yarasi seenuyar...@gmail.com wrote: Hi Skanda, Updated pivot with quantity column too regards Srinivasulu Yarasi On Wed, Dec 16, 2009 at 1:41 PM, Srinivasulu Reddy Yarasi seenuyar...@gmail.com wrote: Hi Skanda, Attached excel file with sample. U can delete two records of Srini refresh pivot table. U will get data for for the example u specified. regards Srinivasulu Yarasi On Wed, Dec 16, 2009 at 2:17 AM, Skanda skanda.pokkun...@gmail.comwrote: can we get percentage in pivot table? say for instance i have physican payer Mg_dispensed columns Samuel Aetna 100 Samuel BCBS 200 Samuel wellcare 200 when we do a pivot can we get something like this: samuel Aetna 10020% samuel BCBS 20040% samuel wellcare 200 40% -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers
Re: $$Excel-Macros$$ PIVOT TABLE AND PERCENTAGE
Anish, Thanks for the quick turn around.Can you tell me how to get the solution.I have data that has 20,000 rows. Skanda. On Thu, Dec 17, 2009 at 2:28 AM, Anish Shrivastava anish@gmail.comwrote: Hi Skanda, Attached please find the solution..Lemme know if the format is according to your requirements.. Cheers!! ANISH On Wed, Dec 16, 2009 at 8:46 PM, Skanda skanda.pokkun...@gmail.comwrote: Srini, Thanks for the response.Let me explain my requirement. We need the percentage at the physician level. say for instance, Srini has total qty 30. so the BCBS for srini is 10/30 which is 0.33% and wellcare for srini is 20/30 which is 0.66%. we should not combine samuel total with srini total to get the percentage at phy level. and could you if you can..explain to me in steps how to get the pivot table if you have a solution. Skanda. On Wed, Dec 16, 2009 at 3:13 AM, Srinivasulu Reddy Yarasi seenuyar...@gmail.com wrote: Hi Skanda, Updated pivot with quantity column too regards Srinivasulu Yarasi On Wed, Dec 16, 2009 at 1:41 PM, Srinivasulu Reddy Yarasi seenuyar...@gmail.com wrote: Hi Skanda, Attached excel file with sample. U can delete two records of Srini refresh pivot table. U will get data for for the example u specified. regards Srinivasulu Yarasi On Wed, Dec 16, 2009 at 2:17 AM, Skanda skanda.pokkun...@gmail.comwrote: can we get percentage in pivot table? say for instance i have physican payer Mg_dispensed columns Samuel Aetna 100 Samuel BCBS 200 Samuel wellcare 200 when we do a pivot can we get something like this: samuel Aetna 10020% samuel BCBS 20040% samuel wellcare 200 40% -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to
Re: $$Excel-Macros$$ PIVOT TABLE AND PERCENTAGE
Srini, Thanks for the response.Let me explain my requirement. We need the percentage at the physician level. say for instance, Srini has total qty 30. so the BCBS for srini is 10/30 which is 0.33% and wellcare for srini is 20/30 which is 0.66%. we should not combine samuel total with srini total to get the percentage at phy level. and could you if you can..explain to me in steps how to get the pivot table if you have a solution. Skanda. On Wed, Dec 16, 2009 at 3:13 AM, Srinivasulu Reddy Yarasi seenuyar...@gmail.com wrote: Hi Skanda, Updated pivot with quantity column too regards Srinivasulu Yarasi On Wed, Dec 16, 2009 at 1:41 PM, Srinivasulu Reddy Yarasi seenuyar...@gmail.com wrote: Hi Skanda, Attached excel file with sample. U can delete two records of Srini refresh pivot table. U will get data for for the example u specified. regards Srinivasulu Yarasi On Wed, Dec 16, 2009 at 2:17 AM, Skanda skanda.pokkun...@gmail.comwrote: can we get percentage in pivot table? say for instance i have physican payer Mg_dispensed columns Samuel Aetna 100 Samuel BCBS 200 Samuel wellcare 200 when we do a pivot can we get something like this: samuel Aetna 10020% samuel BCBS 20040% samuel wellcare 200 40% -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Pivot Table Help count
Hi Subhash, i hope this will solve your problem. Rgds, Mahesh Bisht On Wed, Nov 25, 2009 at 11:50 AM, subhash tambe subhash.ta...@gmail.comwrote: Dear all, How to compile to excel pivot table , ( B Column Count 5 to 15 ) A B C D E F G H 1 2 10 3 25 4 27 5 15 6 13 7 12 8 7 9 9 tell me other formula trick Thanx Please reply me -- Subhash Pratham Mumbai Education Initiative 9870914252 -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- With Love, Mahesh Bisht -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Book1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Pivot Table Help count
Pls clear your question make excel sheet with your data query and attach with this mail. Vir 2009/11/25 subhash tambe subhash.ta...@gmail.com Dear all, How to compile to excel pivot table , ( B Column Count 5 to 15 ) A B C D E F G H 1 2 10 3 25 4 27 5 15 6 13 7 12 8 7 9 9 tell me other formula trick Thanx Please reply me -- Subhash Pratham Mumbai Education Initiative 9870914252 -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- - -- (¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´ Best regards, Veer -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe