I need to do a form in Excel and want to condense it to one form for several
departments to use instead of a separate one for each. I was thinking of
having a sheet with the customer data (name address, etc) a sheet with the
inventory data and a sheet showing just the shipping data which pulls from
the customer and inventory sheets. I am doing just a link for the customer
data which works just fine, but don't know the best way to handle the
inventory info. On the inventory data sheet it is just a table of every
part # available, description, qty, cost, price. On the shipping sheet I
only want to include the inventory items w/ qty's to be shipped. Is this
possible in Excel?

I was told that I could use VLookup or Conditional Formatting to do this, but I can’t figure it out.

Here’s what I have

Sheet 1 contains customer name and address

Sheet 2 contains a list of part #’s and names w/ a blank column to enter the qty.

Sheet 3 is the order which is a link to sheet 1 showing only the customer shipping address AND (this is the part I can’t figure out) the part #’s and names that have a qty greater than zero.

I have Excel 2003. Thank you in advance for your help.