Linking access records in to excel

  • Thread starter Thread starter jho
  • Start date Start date
J

jho

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(insert>name>define). 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
 
Back
Top