This question will be very convoluted if I try to type it out, so I've attached the workbook to refer to in order to illustrate the issue. Essentially I'd like to be able to change where I begin adding "alternative models" and starting from that column I'd like it to add data from a row in Model1! .
If and when I change the number to 2 it will additional begin adding data from Model1! from the beginning again.
I know I can manually do this but only works if I know exactly which month I want to begin in. But I want to be able to show what would happen if I start adding alternative models in different months.
I'm open to all sorts of suggestions as my excel knowledge is basic but I know it has a lot of capabilities.
Thank you for any information or ideas you may have!!
Workbook1.xlsx
Bookmarks