Showing ranges using a combo-box

  • Thread starter Thread starter doltish
  • Start date Start date
D

doltish

I have a bunch of data with a Date corresponding to each record. I
would like to have a combo box that allows users to choose ranges of
time, for example:

Last 30 days
Last 60 days
Last 90 days
All dates

When a user chooses one of these, all dates in my large list that
correspond to their chosen option get displayed below the combo box.

How can I go about accomplishing this?

I realize it may be simpler to do in Access - but Access is too
bulky/complicated for my userbase, not to mention it is not as common
as Excel. Besides which, my Query skills are severely lacking.
 
I'm also looking for a second set of validations where each record has a
Type associated with it. I'd like to be able to allow users to
designate which kinds of records are shown within the Date range that I
posted above.

Am I getting in over my head here? Or is this something I can
accomplish with a days work?
 
If you use some of excel's builtin features (and a little training for your
users), then you could be done setting it up in a minute or so.

Instead of using a combobox, select your range (the last header row through the
bottom of your data) and do:

Data|Filter|autofilter

Then teach your users how to click on the dropdown arrow for the field/column
with the date.

The can choose a single date or they can choose custom and specify the start
date and the end date.

They can choose "Is greater than or equal" "AND" "Is less than or equal" and
use the dropdowns to pick dates.

Then they can go to other fields and even refine their search by filtering on
that.

Then when they want to see everything:
data|Filter|Show All

(I find that quicker than resetting each of the filters that I applied.)
 
Back
Top