Link to home
Create AccountLog in
Avatar of Sharath S
Sharath SFlag for United States of America

asked on

Excel VBA - Conditional copy data from one sheet to other

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
Avatar of als315
als315
Flag of Russian Federation image

Try to prepare sample. One sheet with data and other one with expected result
ASKER CERTIFIED SOLUTION
Avatar of Michael
Michael
Flag of Belgium image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Sharath S

ASKER

Thanks JazzyJoop for your help.