Hi Vic,

Try using the Autofilter feature.

Turn on the macro recorder while you perform the required operations. This
will provide you with code which can be edited to enable general
application.

If you have any problems with such editing, post back with details.


---
Regards,
Norman


"Vic" wrote in message
...
Hoe do i set up a Macro to look for certain information on a worksheet
then
take it out and open a new worksheet and paste it there?

Is this possible?