I have been asked to work on an Excel spreadsheet to search for information
on one sheet by using dropdows on a 'User' sheet.
The result of using 3 separate dropdowns will show the results in the cells
directly beneath the pulldown boxes on that same sheet.

Anyone have a good idea of how this is done.
I have an idea of how Access forms and queries would make this work but I"m
not sure just what to start with in Excel.

Any help would be greatly appreciated.

Dave French
MOS XP Master Instructor
(Who is feeling more and more inadequete every day!!)

Use Auto Filter... Data-Filter-AutoFilter

--
Regards,
Dave


"David French" wrote:

I have been asked to work on an Excel spreadsheet to search for information
on one sheet by using dropdows on a 'User' sheet.
The result of using 3 separate dropdowns will show the results in the cells
directly beneath the pulldown boxes on that same sheet.

Anyone have a good idea of how this is done.
I have an idea of how Access forms and queries would make this work but I"m
not sure just what to start with in Excel.

Any help would be greatly appreciated.

Dave French
MOS XP Master Instructor
(Who is feeling more and more inadequete every day!!)

I had entertained that thought and it most certainly works...for those that
are somewhat Excel savvy.
This is aimed at being used by those that understand the use of a dropdown
and not much else.
We want it brainless with as few choices as possible.

I hate 'dumbing down' Excel just as much as next Microsoft guru!
Unfortunately until the majority of the world is computer savvy...we will be
forced to utilize the bottom 10% of these wonderful programs full
potential!!

Dave



"David Billigmeier" wrote in
message ...
Use Auto Filter... Data-Filter-AutoFilter

--
Regards,
Dave


"David French" wrote:

I have been asked to work on an Excel spreadsheet to search for
information
on one sheet by using dropdows on a 'User' sheet.
The result of using 3 separate dropdowns will show the results in the
cells
directly beneath the pulldown boxes on that same sheet.

Anyone have a good idea of how this is done.
I have an idea of how Access forms and queries would make this work but
I"m
not sure just what to start with in Excel.

Any help would be greatly appreciated.

Dave French
MOS XP Master Instructor
(Who is feeling more and more inadequete every day!!)