Filter & Column Condition

Hi All,

Looking for solution. I have few columns with headers however code should consider two columns. 1st – Customer & 2nd Parent

1. Apply filter on Customer column contains “ZUR” word
2. If ZUR word found in customer column then update Column Parent as “ZURNET”

Exception – Columns place in not constant it moves all the time. Please refer Sample file.

Sample File – PROBLEM Statement & Answer

Thanks for writing code which is perfectly working...!!!!