How to copy data to new tab depending in word in a second tab

[Edinson]

Please HELP!!!

The program below is looking at the Field "Organisation" in the "Data" tab and copies any data that matches the exact contents on Column A in the "Buss Type" Tab into a new Tab called "Target-Data"

Could you show me how to change it so that it copies into the "Target-Data" Tab any data that contains the word listed in Column A in the "Buss Type" Tab any where in the content of the Field "Organisation" in the "Data" Tab?

Please Login or Register  to view this content.

[Edinson]

[Edinson]

Can Any guru help please??

[Edinson]

Can Someone help me with this please?

[AB33]

Please attach a sample with a desired result.

[Edinson]

Thanks AB33.

Please find attached a data file as it should end up.

[AB33]

Edinson,
This is no exact match, hence the code you have is not returning anything.
There is no exact word "PLUMBING" in sheet Data column B. You have a sentence.
I can do a partial match, but you might get some unwanted lines.

[Edinson]

That will be fine. That is what I want. As long as the Word "Plumbing" or any other word in the Buss Type Data Sheet appears in Column B of the Data Sheet.

[AB33]

Try the attached.

[Edinson]

Hi AB33,

This has worked but only it only copies one line. It copies the line which has "CLEANING". Also it does not copy the Header line.

[Edinson]

Hi AB33,

This has worked but only it only copies one line. It copies the line which has "CLEANING". Also it does not copy the Header line.

[Edinson]

Hi AB33,

I tried this again and it is now working correctly. I don't know what I did before, but it works!!! Thank you very much for your help on this