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!