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 <at>yahoo<dot>com
----
"Patrice" <[email protected]> wrote in message
news:[email protected]...
> 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.