[Solved] Exclude Blanks from copying

Discuss the spreadsheet application

[Solved] Exclude Blanks from copying

Postby tehmontyj » Tue May 14, 2019 9:55 am

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 614 times
Last edited by Hagar Delest on Tue May 14, 2019 8:52 pm, edited 1 time in total.
Reason: tagged solved
OpenOffice 4.1.2
Windows 10 Pro
tehmontyj
 
Posts: 2
Joined: Tue May 14, 2019 9:50 am

Re: Exclude Blanks from copying

Postby RusselB » Tue May 14, 2019 3:36 pm

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)
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5305
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Exclude Blanks from copying

Postby tehmontyj » Tue May 14, 2019 4:47 pm

This worked exactly how I wanted. I appreciate the help so much!
OpenOffice 4.1.2
Windows 10 Pro
tehmontyj
 
Posts: 2
Joined: Tue May 14, 2019 9:50 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 23 guests