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
-~----------~----~----~----~------~----~------~--~---
Book4.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
