Excluding Blank Cells

[Bigslim]

I am trying to find out how to eliminate blank cells from an invoice program I am creating.

I have 1 customer ordering product from multiple Venders, and I have created an Order Form to send to those Venders. But now I want to gather all the data from each order form and create an Invoice sheet and set it up to send to the customer so they get one sheet and not multiple sheets.

Another way I thought of doing this same process was by writing info in one sheet for the customers Invoice and have Excel divide the order up according to the code.

Which ever is easiest. all product is coded per vender.
Vender ABC code would look like this ABC-123
Vender DEF code would look like this DEF-123

 

[jbeaucaire]

I would handle this by:

1) making sure I had a database of product codes that listed the vendor for each code
2) on the order sheet, when the client enters a product code the vendor would appear automatically on the same row via a VLOOKUP() formula
3) When I wanted to parse the products for one vendor, simply apply an AutoFilter to the vendor column so you can see/copy/print just those rows, whatever you want to do
4) repeat for each vendor on the order form in the vendor column

 

[Bigslim]

So I like the idea but I think I have gone with a different idea, and it's along the same topic.

Customer Invoice Form
ABC-123 Product 1
DEF-456 Product 2
GHI-789 Product 3


Vender Order Forms(separate forms/tables)
Vender ABC

Product 1
----------------
Vender DEF

Product 2
----------------
Vender GHI

Product 3
----------------
....unfortunately i gotta go so if u can understand what I have here...it is the format I want it with no Code on the vender copy. but I might have multiple Items for 1 vender so the formula I thought of wont work.