D
Davies_Jen
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) I would like to keep an item price list in sheet1 and leave a blank column for order qty. Then in sheet2, I would like to create an invoice for all items with a qty greater than zero in sheet1. I want to pull all item# and the price for all rows with a quantity.