Filter List by Keyword & copy the result in column by keyword as header

[kitunga]

Greetings to All,

I have a long list of items(1000's) in column A & a keyword list(<1000's) in column B, i want to search the list using the keyword list, and the result to be put in individual column in the same sheet or another but with a header beeing a keyword.

The list if Alpha Numeric(ie:WD40) and not case sensitive.

Colum A

screwdriver
bolt5mm
nut7mm
maskingtape
painttape
plier
nut3mm
electrictape
drainagetape

column B

nut
tape
plier
bolt

Result
nut2mm
nut5mm
plasticnut
nut-Germany
nut-012

I appreciate and thank you in advance,as i have been on google for several days trying to find how to do it.

[jraj1106]

Hi.

Try this macro code:

matchdata.xlsm

[kitunga]

Hello,

Wow that was quick, much appreciated, but there maybe i wasn't clear in my explanation. In the keyword list the macro will take the 1st entry, search for it in the data list and pull all the matching keyword and plug them in a column , then go and check the 2nd keyword and pull all the matching ones in a 2nd column. So we will have a column for "nut" another for "tape" etc.. i think maybe now it's much more clear. Again i really appreciate.

[jraj1106]

Check this out:

matchdata.xlsm

[kitunga]

Merci Beaucoup mon ami de Port Louis... really appreciate...