I am not sure is this is a function or a simple formula set.

My Sheet 1 "Inventory" has 150 rows of item data with column 2 ("B")
holding an inventory amount .... either 0/empty or a value 0

I would like to populate rows of another fresh Sheet (Sheet 2) only if
Sheet1 Col "B" 0
(i.e. there is inventory of that item)

Thanks
-scot

(I can do this with AutoFilter... but it requires an intermediate sheet for
my work...and confuses our "sharing" of workbooks...so I am looking for a
formula, or if needed a function)