Need vba to replace exisited data depends upon sheet range value

Hi Experts

I have set of data, i want filter it and change values depends upon list.

for e.g column G:G filter "FO", then column K:K filter select "Off Shore-Client & On Shore-Client"

then check table array in sheet task_list ,depends upon emp name need to replace old values in column F & G.

Please find the attachment include expected result sheet.

thanks and regards

See if this is how youo wanted.

Please Login or Register  to view this content.

Thanks for smart code its solved boss!!!

HI boss sorry for disturb u again, i have small issue i moved column F&G to H&I and chaged in code but it not give 100% result pls have look sheet
i changed column end

Please Login or Register  to view this content.

Are you sure about your attachment?

Seems working for me, but your result looks strange.

yes i made changes in column and run code i moved column Business Unit and Finance code to H&I from F&G in raw_Data sheet.
i didnt get result

You have less columns in your result sheet, but I assume it would be the same, am I correct?

If so, you need to explain why Finance code of row 11 changed to SOE, which is not even exists in Task_List.

No sir i didnt change manually i made changes and run code see result file difference actual and expected

That's more confusing, upload a workbook with the raw data and EXACT RESULT that you want without fail.

HI sir pls find the attachement with raw data and exact result sheet!! this is my actual requirement, sorry for annoying u sir forgive me

Is this the last change?

Please Login or Register  to view this content.

Thanks Alot Sir, Solved!!!Thanks for valuable time spend on me i learned now make changes in your code