Custom Filter

I have an Excel 2010 sheet and I would like to select a cell and filter the entire sheet only showing the rows that contain that info. I have attached some sample data. For example I would select the cell that has "Lighting" in it and then show only the rows that have the word lighting somewhere in them. I can then undo that filter and this time maybe select a cell that has "Jets" in it and just show the rows that have Jets somewhere in it.

I did start a thread in the formulas and functions section and it was suggested that I post here. Below is the post.

http://www.excelforum.com/excel-form...filtering.html

I am no VBA expert, so any suggestions/ideas would be appreciated.

Thanks

Excel Filter.JPG

Boy Mick, that is really close. I extended the range to go from column D to AC. Attached is actual data. I selected cell M1 for the filter "4x LED's /Northern Lights". I did get some rows that don't have that. It's real colse Mick, thanks for your effort.

Change the Set Rng--, line, to line below:-

Please Login or Register  to view this content.

Try this:-

Please Login or Register  to view this content.

Regards Mick

Mick, that seems to have done the trick. Thank you so much. I hope I can return the favour some day. Thanks again.

You're welcome