I have an inventory spreadsheet with four columns.

ITEM : AUTHORIZE : ON HAND : ISSUE : COMMENTS

The scannable barcodes have been pasted into the comments column as images. There are currently 52 of them.

What happens is that the ITEM queries a VLOOKUP table to get the ON HAND amount.

AUTHORIZE is a static number that rarely changes. Once the ON HAND has been inserted it is subtracted from AUTHORIZE and the result is placed in the ISSUE column.

The COMMENTS has a barcode image pasted onto the cell. The idea is when the parts are pulled from the warehouse they can be scanned out right there. Or a comment can be handwritten if needed.

The problem:

I would like to filter out all the rows with a zero in the ISSUE column. So, when I apply the filter the majority of the rows will hide. And, the majority of the barcodes hide with their respective row. But, somewhere near the end a few barcodes wont hide along with the rows and so will be in the wrong place. That kills the notion of only printing one page instead of thee to five pages.

I've checked each images properties and all appear to have the same properties except size as some codes are longer or shorter. The failure to hide seems to happen in the last half a dozen or so parts, usually. So far there is only one that fails to hide no matter what. And I cannot find anything different about it.

Thanks in advance.

Phil