Dynamic Range Setup...
What are you going to do with this range?
Assuming the years are in B1:J1, and the dropdown is in A2, try
=INDEX(INDEX($B$1:$J$1,MATCH($A$2,$B$1:$J$1,0)):$J $1,0)
--
__________________________________
HTH
Bob
"Trevor Williams" wrote in message
...
Hi All
I'm trying (without success) to build a dynamic named range as
follows:
I have a row of variable sequential years
2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
The user can select a 'start year' from a dropdown list created from
the years above.
I then need to create a dynamic range to only include years after the
start date, but up to a maximum of 5 years.
So, if the user selects the start year 2005, the the end year list
would be
2006 - 2010
However, if the user selects the start year 2009 the end year list
would only include
2010 - 2011 as 2011 is the last year available...
I've checked Debra Dalgleish's site regarding this type of thing but
just can't crack it!
Any help appreciated.
Trevor Williams
|