Update sheet1 with Data sheet in same workbook

S

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

Ron de Bruin

Hi Scorpvin

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Emailing a sheet from a workbook with VBA 0
Update from another sheet in same workbook 0
how to update a record from combo-box in user form? 0
Remove all empty rows in a worksheet 2
How to append data from different sheet and different workbook? 2
Update cell links between 2 excel file without opening source file 0
VBA Macro to Create Sheets Based on Column of Values 1

Top