I'm trying to set up a way to search for information on individuals in a
worksheet that's pretty long (some 20,000 rows). The way it's set up now is
that we sort ascending, expand the search, find the name of the person we're
looking for, then look for what we want from there. The problem with this is
that the data is monthly information from March of 2004, and has been set up
until December of 2006 (linked to several other workbooks), and will expand
on indefinitely into the future. This means if I want to know what John Jones
did for the last year, I need to look through 34 entries to find what I want,
copy and paste it into another workbook, then find averages, etc from there.
Still MUCH better than looking through 20,000 rows, but what I'd like to do
is pick from a drop-down list in a ComboBox on a UserForm a name, then choose
a date range, I assume a ComboBox also or maybe option buttons, so that only
the needed information is displayed, along with averages, etc, and can then
be printed. Each person's name and data are on one row, and there are 15
columns of data.

I'm building this for a user who is all but computer illiterate, so the
easier to run the better. I'm getting better with VBA, but still have a very
long way to go, and can't figure out how to make this work. I know Access or
Crystal Reports would be great for this, but I can't use those. Any
suggestions? Thanks for your help.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200507/1