Hi Scorpvin

Why not use AutoFilter to filter for 20 and copy the filter result to Sheet1

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Scorpvin" wrote in message
...

I'm trying to update Sheet1 with information from the Data tab. I want
it to pull all rows that contain a "20" in the Coacct column from the
Data tab. I'm not real great with VBA so I was hoping to get some help
from the VBA gurus. Please help!


+-------------------------------------------------------------------+
|Filename: TestFile.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5257 |
+-------------------------------------------------------------------+

--
Scorpvin
------------------------------------------------------------------------
Scorpvin's Profile: http://www.excelforum.com/member.php...o&userid=27678
View this thread: http://www.excelforum.com/showthread...hreadid=574329