Help..Code for filtering a criteria and print an output

[Dinesh_Excel]

Hello Friends,

Need your help for a Data,where I apply filter to few columns in excel and update remarks in one column manually.Can you please help me with a vba code.

The conditions are as below :

Attached sheet for your reference with Read me file along with base file

 

[Dinesh_Excel]

Hi Friends,

Request your help on the same ..
Appreciate your help

 

[Khalid NGO]

Hi Dinesh,

If you are okay with formula based solution, try this in cell U2 and copy down:

=IF(COUNTIFS(R2,"TP -*",G2,"<>L3_MIGRATION /",G2,"<>L1_CORE /",G2,"<>L3_WG1_BDF /",G2,"<>L3_USR_ERP /"),"FUT",IF(COUNTIFS(R2,"<>TP -*",G2,"<>L3_MIGRATION /",G2,"<>L1_CORE /",G2,"<>L3_WG1_BDF /"),"SIT","Not in Scope"))

Regards,

 

[Dinesh_Excel]

Thanks you Khalid ...this was very helpful
Thank you again ...appreciate your help

 

[Khalid NGO]

Hi Dinesh,
Glad it helped...

Thanks for the feedback, keep visiting.

Regards,