Need help determining which formula/function to use

[westvillage9]

Hi,

I have a "waterfall" / stream of revenue numbers going across a row in Excel, starting with January 2015. I need to sensitize the model so that I can shift the timing of the start of this waterfall.

I would like to build a toggle on my output page which lets me select which month I want the waterfall to start, and dynamically fill in that row starting with whatever month I select. For instance, a dropdown where I select "March 2015" and the first figure of the series (currently in January) will start in March.

Any suggestions for how to do this would be greatly appreciated! Thanks so much

 

[GerryZ]

Hello and welcome on Mr.Excel message board
Why don't you put a sample with few rows and columns with the expected outcome
that's make every thng easy!