FilterAndCopyData.xlsm

<div>
Thanks a lot. This is more than what i expected.i shall change the code to suit to the actual data.
</div>


<div>
You're welcome Kishore! Glad to help.
</div>


<div>
<div class="content wysiwyg-content">
Need to filter on each region (Column F) and copy the result to a new worksheet. would be helpful if this can be done through looping as the original data set contains more regions. Thanks for the help<br />
<a href="https://drive.google.com/file/d/0B02...5nbDlvME0/view" rel="ugc nofollow">https://drive.google.com/file/d/0B02...5nbDlvME0/view</a><br />
<br />
thanks
</div>
</div>


Need to filter on each region (Column F) and copy the result to a new worksheet. would be helpful if this can be done through looping as the original data set contains more regions. Thanks for the help
https://drive.google.com/file/d/0B02...5nbDlvME0/view

thanks

VBA to autofilter in a specific column for each criteria and copy the result to a new sheet

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.