That sounds like you are describing and Autofilter found under the data
menu.

Data=Filter=Autofilter

--
Regards,
Tom Ogilvy

"jho" wrote in message
oups.com...
I have an invoice in excel with 4 columns(SKU, DESC, QTY, AMOUNT). I
want to be able to hit a drop down to select the SKU that is the
primary key in my access table. Right now I have to type everything
from scratch in each column when i make an invoice. I've explored
making another worksheet with all of my data and then for each row
selecting the appropriate info via a drop down(insertnamedefine). In
this case I have to do it 4 times instead of just once and make sure
that all of the data across the four columns belongs together. Any
solutions?jho