Hi, I update the macro as per your use and assign a shortcut too. There are some guidelines follow them to use desired result.
Regards
Sandeep
On Tue, Oct 6, 2009 at 11:35 PM, Umesh Matkar <matkarum...@gmail.com> wrote:
>
>
> Dear Friends,
> I have one query regarding macro.
> i want to record a macro for goal seek.
> Attached reference sheet says following
>
> Column A - my goal starts from 2009 for 16 years till 2024.
> B - Accumulated amount equal to one row up for column E
> C - goal seek result i.e investment amount, please refer below macro
> Sub Macro1()
> '
> ' Macro1 Macro
> '
>
> '
> Range("E18").GoalSeek Goal:=2032281, ChangingCell:=Range("C3")
> End Sub
>
> Column D - interest rates
> Column E - Future value of present investments with given interest rate in
> column D
>
> What i have done in this is that i got a target amount of 2032281 which i
> want after 16 years. So the amount what i have to invest monthly with given
> interest rate acquired from goal seek in cell C3.
>
> Challenge is goal years may vary, say it may be for 20 years or 25 years or
> 50 years also not sure. One thing is sure that the interest rate for last
> five years will remain same as given but for remaining previous years it
> will be as what is in starting.
> E.g: if you see in this sheet first 11 years interest rate is same and last
> five years we have to keep interest rate same what is given
> but if we go for 20 years then last five years interest will be same what
> is given. but for prior 15 years interest rate has to be change what is
> given for 11 years above. accordingly table should be prepared and goal seek
> features should also be used in macro.
>
> I am attaching the file. Please revert in case of any questions.
> Please help.
>
>
> Thanks
> Umesh
>
>
>
>
>
>
>
>
> --
> Warm Regards,
>
> You mesh
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
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
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~----------~----~----~----~------~----~------~--~---
goalSeek Solved.xlsm
Description: application/vnd.openxmlformats-officedocument.spreadsheetml
