Here's what I would do.

I would copy my 10 columns then paste it into the other worksheet (paste as
link) then use a filter.....filter by values greater than 0 in column F.

HTH
Jean-Guy

"Rikki-Handgards" wrote:

Hi. Is there a way to list, on a separate sheet, only rows of data with a
value in a specific column? I want to list inventory items (and all data in
that row) as long as there is a value in column F. If there is no value in
column F for that inventory item, I don't want it to be the separate summary
sheet. Is there a way to do this with a formula and not a pivot table?
Thanks!