How to Add Only Cells With Values

[c.clavin]

Hey guys, I'm attempting to create a Purchase Order from items selected on my 'master inventory list' and transfer those items to a 'Purchase Order' sheet that is formatted the way I'd like for printing/faxing purposes. My 'master inventory list' is ~800 rows, so there's no way I'd want to print ALL of them out on a purchase order, in addition to confusing my vendors. I'm pretty sure there's a formula to exclude all cells without values. Can someone here please help me? Thank you very much.

I've included a photo of the Purchase Order sheet on the left, and 'Master Inventory' list on the right to make it clearer.

QUESTION_zps515a9bf5.jpg Photo by cclavin1 | Photobucket

 

[c.clavin]

Can I take all of the cells and make a pivot table, and use only the cells with values?

 

[JoeMo]

The SUM function excludes text and blanks.

 

[c.clavin]

The SUM function excludes text and blanks.

Thanks. Would this keep my categories and individual numbers as well?

 

[JoeMo]

Thanks. Would this keep my categories and individual numbers as well?

Sorry, I don't know what you mean by that. Try posting your data directly to this site.

 

[c.clavin]

Sorry, I don't know what you mean by that. Try posting your data directly to this site.

I want to use columns in my master inventory list to make up purchase orders on my purchase order template. If I have Column A saying apple, orange, pear, banana, pineapple, lemon and Column B saying 1,2,1,0,2,1 how do I transfer all cells besides 'banana' to my purchase order sheet? I have a master inventory list of over 700 items, but obviously I don't order every item every time. I'd like to take all cells with 0's or no values and hide them for the purchase order sheet, showing only the items with 1,2,3,etc in the 'ordered' column. Is this possible?

 

[JoeMo]

Filter the quantity column on your Master using greater than 0, then copy and paste the visible cells to your purchase order sheet.

 

[c.clavin]

Thanks for the response, I was looking for something that would take the 'non zero quantity' cells and auto-input them into the purchase order template for automatic processing. Do you know of any way this would work?

 

[JoeMo]

Thanks for the response, I was looking for something that would take the 'non zero quantity' cells and auto-input them into the purchase order template for automatic processing. Do you know of any way this would work?

That can be done with VBA. Whoever writes the code will need to know the layouts and names of both sheets so the correct data can be extracted and placed in the right place.