Search results

Thanks Luke. That was an odd one. The two sheets were "corrupt" what was causing the issue was down around cell 800 or so of the A column was a name? ... some how an = sign was in front of the name. Thanks again.

This has been working great, but I ran into two worksheets this morning that stopped the macro. When going into the debug mode, the following line is highlighted: If c2 Like "*" & c1 & "*" Then What do I need to do to resolve? (what is causing the error?) Thanks!

For readers of this. Luke's solution was exactly what I needed. Further, to add the ability to filter off the unwanted xyz product kits, or xyz product kit. By putting two cells in the J column, one with kits and the other with kit (where I put a space after the word kit. This allows the...

Luke, You are Awesome! Thank you!

Thanks Luke M. This is my first time to use a macro, but I unhide the hidden workbook, "recorded a macro" (doing nothing and then saving it -didn't know how else get the information in). I then editted the Macro (removing everything and pasted your code). I ran the macro and saw some items...

Here's the scenario: Column A has over 1,000 rows of text phrases. Column J contains text that I want to use to compare against column A, such that if a cell in Column A contains the text in any of the cells in column J, the cells in column A will be highlighted (or take the same formatting I...