$$Excel-Macros$$ Query related to subtotal and condition
Dear All members, I am attaching herewith a file regarding tds and the requirement is mention in that file related to subtotal and conditions. Please solve my problem . Thanks to all in advance Regards LKModi 9309243685 -- FORUM RULES (934+ 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 TDS 2011-12.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Query related to subtotal and condition
Dear Mr. Modi, Attached is the soln. pl chk if this is ok. Regards, Andy On Sat, Nov 12, 2011 at 12:09 PM, L.K. Modi wrote: > Dear All members, > > I am attaching herewith a file regarding tds and the requirement is > mention in that file related to subtotal and conditions. Please solve my > problem . Thanks to all in advance > > > Regards > LKModi > 9309243685 > > -- > FORUM RULES (934+ 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 > -- Warm Regards, Aindril De Ph: 9811300157 -- FORUM RULES (934+ 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 TDS 2011-12-Modi.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: [bulk] $$Excel-Macros$$ Query related to subtotal and condition
PFA Best Regards Momin Siraj Ahmad From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of L.K. Modi Sent: 12 November 2011 10:39 AM To: excel-macros@googlegroups.com Subject: [bulk] $$Excel-Macros$$ Query related to subtotal and condition Importance: Low Dear All members, I am attaching herewith a file regarding tds and the requirement is mention in that file related to subtotal and conditions. Please solve my problem . Thanks to all in advance Regards LKModi 9309243685 -- FORUM RULES (934+ 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 (934+ 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 TDS 2011-12.xlsx Description: TDS 2011-12.xlsx
Re: [bulk] $$Excel-Macros$$ Query related to subtotal and condition
Pivot table can give you a summarized result. Would be easier to use, and quicker than VBA, and it can also accommodate data automatically if the source is assigned using a dynamic range. Anyway, a simple example of a pivot for your data is attached. Regards, Sam Mathai Chacko On Sat, Nov 12, 2011 at 9:07 PM, dguillett1 wrote: > Save your file as .xls or .xlsm and use this. See attached. > Option Explicit > Sub MakeSummaryTableSAS() > Application.ScreenUpdating = False > Dim i As Long > Sheets("april-11").Range("C:C,G:G,I:I").Copy Columns(1) > For i = Cells(Rows.Count, 1).End(xlUp).Row To 3 Step -1 > If Cells(i + 1, 1) = Cells(i, 1) And _ >Cells(i + 1, 3) = Cells(i, 3) Then >Cells(i, 2) = Cells(i, 2) + Cells(i + 1, 2) >Rows(i + 1).Delete > End If > Next i > Columns.AutoFit > Application.ScreenUpdating = True > End Sub > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Siraj Momin (BTG) > *Sent:* Saturday, November 12, 2011 1:13 AM > *To:* excel-macros@googlegroups.com > *Subject:* RE: [bulk] $$Excel-Macros$$ Query related to subtotal and > condition > > > > > PFA > > > > Best Regards > > > > * * > > Momin Siraj Ahmad > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *L.K. Modi > *Sent:* 12 November 2011 10:39 AM > *To:* excel-macros@googlegroups.com > *Subject:* [bulk] $$Excel-Macros$$ Query related to subtotal and condition > *Importance:* Low > > > > Dear All members, > > I am attaching herewith a file regarding tds and the requirement is > mention in that file related to subtotal and conditions. Please solve my > problem . Thanks to all in advance > > > Regards > LKModi > 9309243685 > > -- > FORUM RULES (934+ 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 (934+ 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 (934+ 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 > -- Sam Mathai Chacko -- FORUM RULES (934+ members already BANNED for violation) 1) Use c