Make a Macro take out rows and add it to new worksheet
"Norman Jones" wrote:
Hi Vic,
You will need to edit the recorded code to enable use with varying data
groups.
If you post the code you are using, there are numerous people who would be
prepared to suggest appropriate amendments.
---
Regards,
Norman
"Vic" wrote in message
...
"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.
December 2, 2005 - 10:21 AM..
|