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