Macro That Runs Goal Seek From a List and Pastes the Output

[polkadotbikini5]

I am currently trying to create a macro that runs a Goal Seek on multiple Projects.

I have a summary worksheet that contains a list of projects, their revenue and expense streams by year. I then have a worksheet that contains an IRR template that uses index match to pull in the revenue and any associated expenses based on the name of the project. I need to determine the break even capital investment for each project.

In the past I have created a macro that runs the Goal Seek on multiple worksheets, with each worksheet containing the IRR template and specific to each project. However, I want to condense this so I can minimize the amount of worksheets within my workbook. I am hoping that someone can help me write a macro that does the following:

On the "Breakeven Capital Template" worksheet, in cell B3, pull in the project name from a list on the "Inputs" worksheet, run Goal Seek, and then paste the value in G7 into the column to the right of the project name on the "Inputs" worksheet. The below code is what I get when I record the operation for 1 item in the project list. Is there a way to just loop this for each project in the list?

Thanks in advance!

Please Login or Register  to view this content.

[Keebellah]

Hi welcome to the forum
Please use the code delimiters when entering code
Makes it readable, aside from that I can't help you I'm no good at economics

[polkadotbikini5]

Hi welcome to the forum
Please use the code delimiters when entering code
Makes it readable, aside from that I can't help you I'm no good at economics

Hi Keebellah - how do I use code delimiters? I copied and pasted from the macro module.

[Keebellah]

If you look at the formatting bar above the space where you enter your question there are symbols
The # is the one to select but you can also type

[ code ]

the macro

[ /code ]

no blanks in between the [ ]

the result

Please Login or Register  to view this content.