I have an excel worksheet I am creating for my boss to be able to
easily search our legal records. I have made the worksheet searchable
by creating a list. I need one column where I can input a range of
years, say 2001-2006, to show the range the legal matter was pending.
However, what I want to be able to do is then search the worksheet
where I put in 2005 and up pops the row where I input 2001-2006. I
want to make this as easy as possible for the people I work with so
that they can input the information on the worksheet and then find the
information they need without too many difficult steps. Is there any
way to have them just input ranges like above and then be able to
search the list for years in between? Thank you for any help in
advance as I am indebted to you.

Would autofilter work?

On Oct 9, 12:05 pm, wrote:
I have an excel worksheet I am creating for my boss to be able to
easily search our legal records. I have made the worksheet searchable
by creating a list. I need one column where I can input a range of
years, say 2001-2006, to show the range the legal matter was pending.
However, what I want to be able to do is then search the worksheet
where I put in 2005 and up pops the row where I input 2001-2006. I
want to make this as easy as possible for the people I work with so
that they can input the information on the worksheet and then find the
information they need without too many difficult steps. Is there any
way to have them just input ranges like above and then be able to
search the list for years in between? Thank you for any help in
advance as I am indebted to you.