[Solved] Exclude Blanks from copying

[tehmontyj]

I'm sorry if this has been solved before but I've spent a week trying to google a solution and have yet to come up with a true answer.
So each week I do my liquor inventory and have calc autocalculate my needs based on par levels. What I'd like to do is export this data to a separate sheet, but filter the needs list to exclude items that I no longer need (anything less than 0.5 from my par-onhand is set to 0 and therefore a blank cell). Thus with something having a null value in the need category, I want to remove that from being copied to the sheet entirely (that part in column a) and skip to the next one, creating a composite of needs for me to send to the distributor.
I've attached an image file to give a base example of what I have as per sheet one.
Any help is appreciated.

OeIuN9b.png (10.3 KiB) Viewed 1007 times

[RusselB]

Welcome to the Forums.
I'm going to suggest that you use Data -> Filter -> Standard Filter
That will bring up a dialog that allows you to make settings that can control the information displayed.
Without knowing what format the distributor is wanting the information, you may be able to create the file that they want/need (eg: hard copy or PDF)

[tehmontyj]

This worked exactly how I wanted. I appreciate the help so much!