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
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