Personally, I'd keep the data in one location.

You could apply Data|Filter|Autofilter, then filter on greater than 0 to show
the values that you want.

If you really want this stuff on another worksheet, you could copy those visible
rows and paste into a new worksheet.

Greyson wrote:

I have a large source worksheet containing data in various columns. When a
value is indicated in the "qty" column of the source book, I need the entire
row of information to display and list in a second worksheet. How do I
display only the selected information in the second worksheet?

--

Dave Peterson