Macro to copy duplicate data after checking certain conditions

[shekar goud]

Hi Guys,

How are you doing !!!!

I will come to point directly...I'm sharing sample work here which is pretty self explainatory


I have a sheet which has data in Column D = Unique Account Number,Column j=Code Purpose,Column K=Reason
,Column L=Purpose

I have to copy all those unique account data from column A till last if Column J contains (Cancel),or Column K contains (rejected
),and column L conatins(Cancel).

I have to copy the entire customer details ot next sheet which could be named any lets take (Sheet2).

I'm attaching an sample sheet,If someone could help on this would be really great..I have data around 150 k and its really hard to work on this non-sense data .

Thanks,
Goud

[shekar goud]

Hi Guys,

Any luck on the above query.

If not please help me in building atleast formuale in excel.

Thanks,
Goud