Hi Ayush..yes its working .thanx
One more thing is ..can u suggest me some books for learning excel vba / macro ..from starting to end (means like beginner) means like wht is dim, wht is string ..how its work etc etc. Please. Umesh Matkar From: ayush jain [mailto:jainayus...@gmail.com] Sent: Friday, February 12, 2010 11:58 AM To: excel-macros@googlegroups.com Cc: matkarum...@gmail.com Subject: Re: $$Excel-Macros$$ pls help - Vertical to Horizontal Dear Umesh, Attached is the solution file Please verify and let me know if any further help is required. The below macro has been developed for your requirements: Sub intcalc() Dim amount, intcalc, totInt As Integer For k = 3 To 25000 j = 12 totInt = 0 For i = 2 To 14 intcalc = 0 amount = ActiveSheet.Range(Chr(64 + i) & k).Value intcalc = ((amount * 8.5) / 100) * (j / 12) totInt = totInt + intcalc j = j - 1 Next ActiveSheet.Range("O" & k).Value = Round(totInt, 0) Next End Sub Thanks and best regards, Ayush Jain On Fri, Feb 12, 2010 at 10:00 AM, Umesh Matkar <matkarum...@gmail.com> wrote: I have given here example file and contents . We want interest calculation on Avg Monthly Balance Interest Rate 8.50% P.A Eg First Step (Opeining Balance + April)+ May)+Jun)... Till Mar Then (Total of interest /12*8.50% pls help.suggest any formula or macro for this work I have 25000 Rows in my original file Pls help...excel guru's Thanx Umesh matkar -- ---------------------------------------------------------------------------- ------ 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 -- Best regards, Ayush Jain -- ---------------------------------------------------------------------------------- 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
