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

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