<div>
Try to prepare sample. One sheet with data and other one with expected result
</div>


Try to prepare sample. One sheet with data and other one with expected result

<div>
Thanks JazzyJoop for your help.
</div>


<div>
<div class="content wysiwyg-content">
I have data in Sheet1. Row1 is column headers. Column C name is Title. From Row2 onwards I have data. I want to copy data from Sheet1 to Sheet2 based on data in Title column. I want to exclude the records in Sheet1 if Title has a string like &quot;ABC&quot;.<br />
<br />
Basically, I want to exclude those records in Sheet1 with Title having &quot;ABC&quot; and copy remaining records to Sheet2. Really apprcieate if anyone helps with a Excel VBA.<br />
<br />
Thanks in Advance<br />
Sharath
</div>
</div>


I have data in Sheet1. Row1 is column headers. Column C name is Title. From Row2 onwards I have data. I want to copy data from Sheet1 to Sheet2 based on data in Title column. I want to exclude the records in Sheet1 if Title has a string like "ABC".

Basically, I want to exclude those records in Sheet1 with Title having "ABC" and copy remaining records to Sheet2. Really apprcieate if anyone helps with a Excel VBA.

Thanks in Advance
Sharath

Excel VBA - Conditional copy data from one sheet to other

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.