Page 1 of 1

[Solved] Exclude Blanks from copying

Posted: Tue May 14, 2019 9:55 am
by 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
OeIuN9b.png (10.3 KiB) Viewed 1003 times

Re: Exclude Blanks from copying

Posted: Tue May 14, 2019 3:36 pm
by 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)

Re: Exclude Blanks from copying

Posted: Tue May 14, 2019 4:47 pm
by tehmontyj
This worked exactly how I wanted. I appreciate the help so much!