If cell contains text - return this value and the next 12 rows

[CathalP1992]

Hi there,

Be really grateful for any help on this.

I have a called Front Month where I type manually the current month and year (ie. APR23)

I am looking for a simple way to tell excel if I change this value, that excel should find the next matching value and the X number of rows below it.

So if I change front month value, the series of month values will change based on the front month. There is another helper sheet where I have a list of months from Jan23-Dec25 so that my list will chose the next 12 consecutive.

Any help greatly appreciated.

Cathal.

 

[Sufiyan97]

if you had to explain that what will the diff numbers represent? 1-12 the number of the month from the initial month

I am still not clear with your query, can you please explain more