Copy and Paste Input, then iterate, copy and paste results, and then perform next scenario

Hi All,

I just joined this forums in hope of finding some help with a problem that i have encountered in performing some sensitivities in a financial model. I have basic familiarity with VBA so please be patient. I need to design a macro that allows me to copy a variable from a sheet and paste it into an inputs sheet and then take the output that results from that input and paste that into the cell next to the input in the original sheet.

The difficulty that I see is that I don't know how to actively move the cell that it copies the input from and pastes the output to for each scenario

I need to run this scenario several hundred times so rather than waste 12 hours of my life I figured I would invest some time in learning some basic VBA. Any help would be much appreciated.

Thanks for the quick response Teylyn. I appreciate you taking the time to answer me. I am using microsoft excel 2010. I don't have the code yet. First, I wanted to get an idea as to how I can conceptually approach the problem. I have a financial model for a solar project. I want to see how changing one variable affects the internal rate of return of the project. I have a sensitivities sheet which has roughly 300 different values for this particular variable. For each value of the variable I want to be able to paste it into an inputs sheet. Once I paste it to the inputs sheet, this will affect my cash flow, which will change my internal rate of return. I would therefore like to then grab the internal rate of return that results from me inputing the value of the variable and then copy that onto my sensitivity sheet next to that particular value of the variable. I think I know how to perform a loop to run multiple iterations. What I do not know is how to move the cell down one row to grab the next the value of the variable. Similarly, how can I grab the output and paste it next to that particular value of the variable so that as i go through the scenarios it populates the output for each particular scenario.

I have created a dummy sheet which I think simplifies my problem. I would like to copy the values in D8:D27 in the Scenario Sheet, paste those to E8 in the Input and Output Sheet, and then take the output and paste that to row E in the scenario sheet for each particular value of the variable. Any solution would be much appreciated.

Bumping this thread. If anyone can please provide some help with this I would greatly appreciate it. Thanks in advance and Happy New Year.