Thread
:
Dynamic Range Setup...
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Dynamic Range Setup...
Where h1 has 2004 and h3 is your validation list
=MIN($H$3+5,$H$1)
=$H$3&":"&MIN($H$3+5,$H$1)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett