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?

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

"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?

Thanks Dave -very helpful. One more question...Now that I have filtered the
data, is there a way to have new entries meeting the specified criteria in
the source book added to the list without performing another filter action?

I guess you could loop through each row using that criteria and only copy the
rows that meet the criteria to the other sheet.

But if the criteria is easily applied via a filter, I think I'd just apply that
next filter.

Greyson wrote:

"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?

Thanks Dave -very helpful. One more question...Now that I have filtered the
data, is there a way to have new entries meeting the specified criteria in
the source book added to the list without performing another filter action?

--

Dave Peterson