"Norman Jones" wrote:

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?

Norman thanks for your quick response. I did the filter and it worked but one problem is when i tried it for a previous day it looked for the rows that i highlighted and this messed it up. there are times that i might have 50 rows and otehr times i might have 100 rows so i need to set it up where after i do the filter it will catch all the lines that are there.
your help is greatly appreciated.