Automatic Goal Seek

Hello everyone,

I was wondering if anyone could help me with my Goal Seek problem. I have to manually set goal seek by opening the menu and selecting the cells every time I want to set a down payment or backward calculate a profit rate from a specific installment value. This gets rather hectic when I keep making changes. Is there away where I can use a macros to just set and empty cell for the down payment and one for the installment (monthly rental on the excel sheet attached), so I can enter a number for each and Goal Seek will be calculated automatically?

Kindly find attached is a copy of the sheet I am referring to with notes on how I use goal seek and which cells I would like to set to calculate goal seek automatically.

Thanks a lot and I greatly appreciate you time and efforts.

Ciao,
-T-

P.S. I need the macros to do this for various cars. Thanks again.