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