Hello all, I hope someone can help on this please
I need some VBA to do the following
In Column C2: C9997 I have a description of a part number in each cell
In column D2 & E2 i have Keywords
I want to check the value in D2 & E2 and if they keyword is in C2 then copy the contents of C2, remove only the keyword and paste the answer in F2
Example
C2
This dog wants to go for a walk
D2
dog walk
E2
wants
F2
This to go for a
I need some VBA to do the following
In Column C2: C9997 I have a description of a part number in each cell
In column D2 & E2 i have Keywords
I want to check the value in D2 & E2 and if they keyword is in C2 then copy the contents of C2, remove only the keyword and paste the answer in F2
Example
C2
This dog wants to go for a walk
D2
dog walk
E2
wants
F2
This to go for a