Hi Thank you for spending time for this calculation Its working well Can you make some changes 1 interest calculations (macro result) should be in column after outstanding /advance (last column) 2 for working of interest please considere current interest column figure also (this may be blank or figure also kindly considered like curreny bill
3 macro currently not workiñg after 2nd row.can you please make upto last data becase I have hundreds of members data & can it will work automatically upto last entry because iy will be difficult to manually run macro for so many entry. Thanks. On Jul 1, 2014 5:51 PM, "Vaibhav Joshi" <v...@vabs.in> wrote: > Hi > > PFA > > I have developed macro on my understanding, click button to run macro. > When prompted select row in col A for which you want to cal Int. > > Cal Int will be added in Current Int. column. > > Cheers!! > > > On Tue, Jul 1, 2014 at 4:13 PM, Vaibhav Joshi <v...@vabs.in> wrote: > >> Hi >> >> last Q, how do you calculate current int. (Pt. 4). E.g. Bill is raised on >> 5 Jun & payment recd on 8/Jun, so how you cal int, and you said Total int >> will be charged in next bill, is it current int only? >> >> Cheers!! >> >> >> On Tue, Jul 1, 2014 at 1:51 PM, Kalpesh Shivdas < >> kalpesh.shiv...@gmail.com> wrote: >> >>> Can anyone help on this >>> On Jun 29, 2014 6:56 PM, "Kalpesh Shivdas" <kalpesh.shiv...@gmail.com> >>> wrote: >>> >>>> Hi Vaibhav >>>> >>>> this format is almost fixed means >>>> first Opening Balance then current bill & the receipt against it then >>>> interest (calculate by macros) & then closing outstanding/ advance >>>> >>>> by experience I know during the period not more than 3 receipt received >>>> if macros can calculate more than receipt it is great. >>>> >>>> I have hundreds of members data in contiguous rows so I want interest >>>> calculated in the same row after total receipts column & before >>>> outstanding/advance column >>>> >>>> Regards >>>> >>>> >>>> >>>> On 6/29/14, Vaibhav Joshi <v...@vabs.in> wrote: >>>> > Hi >>>> > >>>> > Is this format is fixed or subject to change? >>>> > >>>> > If format is fixed then is if by chance you get more than 3 receipts >>>> than >>>> > what? >>>> > >>>> > What you want Macro to do? Where you want calculated Interest amount >>>> to be >>>> > shown in sheet? >>>> > >>>> > Cheers!! >>>> > >>>> > >>>> > On Sat, Jun 28, 2014 at 12:15 PM, Kalpesh Shivdas >>>> > <kalpesh.shiv...@gmail.com >>>> >> wrote: >>>> > >>>> >> Hi pramod & vaibhav >>>> >> >>>> >> Thank you for your reply >>>> >> >>>> >> I am still facing the interest calculation problem >>>> >> >>>> >> I have mensioned detail explanation in attached file. >>>> >> >>>> >> Can you please make macros for this calculation >>>> >> >>>> >> Regards >>>> >> On Jun 28, 2014 11:27 AM, "Vaibhav Joshi" <v...@vabs.in> wrote: >>>> >> >>>> >>> Did this got resolved at your end or do you need help on this? >>>> >>> >>>> >>> >>>> >>> On Sun, Jun 22, 2014 at 2:45 PM, Kalpesh Shivdas < >>>> >>> kalpesh.shiv...@gmail.com> wrote: >>>> >>> >>>> >>>> Hi Group >>>> >>>> >>>> >>>> >>>> >>>> Can anyone help me on this >>>> >>>> >>>> >>>> Currently I am using (IF) formula for doing this calculation >>>> with is >>>> >>>> very long & confusing. >>>> >>>> >>>> >>>> I have four values 1 opening interest 2 opening principal 3 current >>>> >>>> bill 4 current bill interest >>>> >>>> >>>> >>>> =1+2+3+4=5 total outstanding. >>>> >>>> >>>> >>>> There are receipts against total outstanding dues these receipts >>>> may >>>> >>>> be one or maximum three times received during the month(period). >>>> >>>> >>>> >>>> I want to adjust these receipts against total outstanding but in >>>> above >>>> >>>> sequence 1 then 2 then 3 & lastly 4. & also calculate the days if >>>> >>>> receipts received after due date days & interest @21% p.a. >>>> >>>> >>>> >>>> Kindly refer the attached file. >>>> >>>> >>>> >>>> if any one can do this with macros or VB coding it will be helpful >>>> to >>>> >>>> me. >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> Thanks & Regards >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> -- >>>> >>>> Thanks & Regards >>>> >>>> >>>> >>>> -- >>>> >>>> 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. >>>> >>> >>>> >> -- >>>> >> 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. >>>> > >>>> >>>> >>>> -- >>>> Thanks & Regards >>>> >>> -- >>> 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. > -- 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.
