Need help using search functions

[cburgess57]

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!

 

[bj]

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