Need help using search functions

Here's my example:
column a will be materials, column b will be total quantity available for
the project, and then columns c-z will be a date, and the amount ordered for
that date.
total added
materials quantity quantity etc. etc.

I need to be able to search the added quantity columns, see if there is an
entry, and then pull only those items there was an entry in, onto another
worksheet....it needs to pull the material name along with the quantityy
added. there may be a list of 20 materials, but only 1 or 2 will be added in
each column....

Any suggestions??

Thanks!

<data><Autofilter> works very well for doing this occasionally.

"cburgess57" wrote:

> Here's my example:
> column a will be materials, column b will be total quantity available for
> the project, and then columns c-z will be a date, and the amount ordered for
> that date.
> total added
> materials quantity quantity etc. etc.
>
> I need to be able to search the added quantity columns, see if there is an
> entry, and then pull only those items there was an entry in, onto another
> worksheet....it needs to pull the material name along with the quantityy
> added. there may be a list of 20 materials, but only 1 or 2 will be added in
> each column....
>
> Any suggestions??
>
> Thanks!