Including wildcard search in this program

Hello, i am currently working on a program to manage a large number of data, what i'm working on right now, is to come out with a code to do a wildcard search in this program and then any of the wildcard search result(the whole row) will be copy and paste into sheet2 of the same work book, so far, i am able to do a wildcard search in the same column. My question is, what should be added into this code to implement a wildcard search in the whole data rather just the column?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

thanks GC EXCEL, the code works great, it's easy to understand but sorry to bother you again, may you explain what does xlValues and xlPart means in this line of code? thanks.