Hello Sergio, Thanks for your support, the file sent by you has a great start.
What I want is, Bank calculate Interest quarterly, now if I have taken FD on 20 May then Bank will calculate interest from 20 May to 20 Aug. As Interest is getting compounded qyarterly. But for our accounting we want Interest calculation for each Financil Quarter e.g. 30 June, 30 Sep, 31 Dec, 31 March. Therefore I want a sheet in which interest is getting compounded on 20 Aug (in above example) but I want a report for interest as on 30 June, 30 Sep and so on. Waiting for your new sheet, Ashish. On Tue, Apr 21, 2009 at 8:17 PM, Sergio Abadesso < groups.abade...@googlemail.com> wrote: > Hello Ashish, > > before I continue to program the solution I wanted to ask if you search for > somthing like it is programmed in the attached file. > > You have to fill the parameters in the Master sheet and click on start. He > creates afterwards a new Worksheet with the solution. > > Its not finished complete yet. I only wanted to have a feedback if this > solution corresponds to your wishes. > > Best Regards, > > Sergio > > 2009/4/21 Galego <groups.abade...@googlemail.com> > > >> Hello Ashish, >> >> I am working on a solution for you! >> >> But I still don't know how to attach a file in an answer. >> >> I'm new in this group and I really want to help people with VBA >> problems. >> >> But before I have to know how I can attach files. >> >> Best Regards, >> >> Sergio >> >> On 20 Apr., 15:51, Ashish got engagged <4everash...@gmail.com> wrote: >> > Hello, >> > >> > I am attaching herewith one excel file in which I have calculated Fixed >> > Deposit Receipt Interest. Plese give me any fixed format so that I can >> just >> > enter the FDR No, amount, tenure, interest rate. So that it will >> > automatically calculate the Interest for each quarter, i.e. June, Sep, >> Dec, >> > Mar end. >> > >> > Thanks, >> > >> > Regards, >> > >> > CA. Ashish >> > >> > FDR Interest.xls >> > 173KAnzeigenHerunterladen >> >> >> --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
