I need a macro that will filter a list in Excel. The list could have up to 10 000 rows. The list has three columns, like this -
TERM WORDS FILTER
[login to view URL] acrylic shelving cottages
[login to view URL] adirondack cottages african travelling
[login to view URL] african travelling
The macro must output into a fourth column, the TERMs that contain any or all of the words in the filter column. My list will have the TERM and the WORDS already separated. All the macro must do, is to filter according to the words that I will enter in the FILTER column.
So, in this case, the output in the fourth column would be
OUTPUT
[login to view URL]
[login to view URL]
That's it.