finding partial string into another workbook, then do several cell copy when found

Hi everyone,

I want to update several lines/columns into a worksheet (ex. WStarget) from another one (ex. WSmaster).

1st: For every lines into WBmaster (ex. L2 to L250) I must find where this "partial string" is located inside WStarget (ex. X2-X1000).
2nd: When I found a match inside WStarget, I want to paste specific columns from WSmaster inside specific columns inside WStarget.


I'm able to find where the "partial string" is located but I'm having problems when trying to fill several columns using Index Match. I wonder if it'll be simpler to use VBA instead.
(Inside WStarget)
=INDEX($A$2:$AA$284;EQUIV("*"&MSmaster!L2&"*";$AA$2:$AA$284;0);2)
(Inside WSmaster)
=INDEX('WStarget!$A$2:$AA$284;EQUIV("*"&L2&"*";'WStarget$AA$2:$AA$284;0);2)

Have yourself a Merry Christmas and Happy New Year btw!



VBA code I'm working on right now:

Please Login or Register  to view this content.