[Solved] Exclude Blanks from copying
Posted: 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.
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.