Hi,

I have data as follows:

Row 1: Current Year: FY0607
Row 2: FY0607 FY0708 FY0809 FY0910 (up to FY20/21)

I want to dynamically name the range in Row 2 so that it runs from the current year until the last year entered.

At the moment i can use the OFFSET function to name the range which will increase when i add years onto the end of the list, however when the financial year changes to FY0708, i need the range to start from there.

Any ideas guys?