Automatic link
 

I have an inventory price list that I would like to link to an Invoice sheet,
so everytime I make an invoice, I will have all the products and price list
available on my Invoice sheet. Can anyone help me? I wasn't sure how to do
it, so I created a list for each category of products on my price list...then
what?? Thank you.

Try Debra Dalgleish's nice coverage of
Data Validation at:

http://www.contextures.com/xlDataVal01.html

and also check out her sample books:

1. Invoice for Selected Number
2. Order Form

at: http://www.contextures.com/excelfiles.html

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Patrice" wrote in message
...
I have an inventory price list that I would like to link to an Invoice
sheet,
so everytime I make an invoice, I will have all the products and price
list
available on my Invoice sheet. Can anyone help me? I wasn't sure how to do
it, so I created a list for each category of products on my price
list...then
what?? Thank you.