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.
Bookmarks