VBA - Single cell with multiple text, search table and return all reports that match the single cell

[rachel_excel]

Hello,

My problem: Doing a lookup in a tables coloumn on a different tab from a single cell with multiple words in it, and returning the row if matches or close

I have 2 tabs "Reports" and "Data". Reports tab has a cell (F11) where multiple text is inserted from a user interface of check boxes. The cell can contain text such as: BlueCarPetrolFast or it contain BlueVanPetrolFast or YellowVanDiesalSlow or RedCarDiesalSlow or RedCar or CarFast etc (you get the picture, many options can be combined or excluded by the selection).
Below is a examples of some of the options the user can select (they all have a check box attached to them). As you can see the user can select a many or little as the like from each coloumn
Colour VehicleType Fuel Speed
Blue Car Petrol Fast
Yellow Van Diesel Slow
Red Mini
Pink

What I want to do is from a single cell (F11)-(checkbox selection displayed in this cell) on Reports tab: is to search a table on the "data" tab.
Below is a example of the data tab table

Search Category report title report abstract report link
BlueVanPetrol title1 abstract1 www.fvsv
BluePetrol title2 abstract2 www.divs
RedPetrol title3 abstract3 www.evsdd
RedCarFast title4 abstract4 www.vdssd

Using VBA I want to be able to search the data tabs “search Category” column for matching text.
e.g. Blue Petrol is in the “reports” tab cell F11….so I want all but the last row to be displayed.
e.g. BlueDiesal is in the cell F11 in the reports tab….none of the rows returned as they have blue But have petrol NOT diesel.
e.g. Red is in call F11 in reports tab…so the bottom 2 rows are returned.

Can anyone help me? Of think of a easier way to make this work….. would having the search criteria in separate cells help (but then there would be about 50 different combinations)

Any help or advice will be received with thanks x