Update sheet1 with Data sheet in same workbook

[Scorpvin]

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 |
+-------------------------------------------------------------------+

 

[Ron de Bruin]

Hi Scorpvin

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