help changing repeating code into array of somekind also copy highlighted rows to new shee

I am repeating the following code many times for varying cell contents. I know there must be a better way. I tried to change the code to array myself but apparently I was not doing something correctly. I am new to this (duh.lol)! I found the code in a forum and changed highlight cell to highlight entire row because the next step is to copy all rows in which are highlighted to a new sheet within the same workbook. Also the cell contents the code is searching for can be anywhere in column A thru M on any given row on the active sheet. I have Excel 2013 and am running Windows8.1.
1. Should I use variant array, string array, named range(no clue how to do but have read about it), or another function?
2.Could you please point me in the right direction as to how to copy highlighted rows to a new sheet?
3.Lastly, should I be highlighting the entire row or just the active cells(as that is all I need) in the needed row? .
Your help is very appreciated!!!

Please Login or Register  to view this content.

Again thank you for taking the time to read my ramblings and helping me!

That is working until it gets to a value in the array for which there is not a match then it ends the sub instead of continuing to search.

This is where I have been getting confused: You set it as variant so I could add strings. What does this mean? How would this be used?

Do I need to define the size of the array? You do mean the columns the value could possibly be in correct?

The wildcard is working very well

Thank you. That one works. but I have to do it twice because i have 2 types of data I am looking for. Is this what you would do?

Please Login or Register  to view this content.

Thanks to the both of you! Any chance I could also get help with the second part of my question? How to go about coping the highlighted cells and pasting into a new sheet?

I must be doing something wrong. I have tried everything I can think of and looked online to get the above code to work because I know it is something I am doing but I cannot get it to stop getting errors. Everything I have tried only gives a new error.

Yes I added a line of code to add the new sheet and used its name in the "new sheet". It creates the new sheet but it stays blank.

Please Login or Register  to view this content.

I can however get this code to work but only if it is saved in the workbook modules not in my personal or if I label the sheet name but I cannot use the sheet name because the sheet name changes each week. I do not know what causes this and cannot figure out how to fix it.

this works in workbook module only:

Please Login or Register  to view this content.

This will work in personal but I need to use sheet code name:

Please Login or Register  to view this content.

Has anyone ever told you that you are amazing!!!!! I would have put money down that I tried that but I guess I didnt do it correctly. Thank you so much this has been driving me crazy! AGAIN you are wonderful!!!!

I have marked as solved and added reputation. Thanks again!