MACRO for searching column for a letter and Copy/Paste the row into new MASTER sheet

Wow that was fast thanks AB33!!!

Nice work, really I appreciate it.

Couple more questions for ya.

Lets say I would want to just copy information from a couple of the columns....Is that hard to do?

Also, instead of just reading an 'X', how would I go about reading 'XX' also? Is that too many of the same characters?

Thanks again

Mind you if you change X to XX, if there is no exact match, we have to change the code from whole match to part match, but it will copy the same rows anyway.

If columns cant be done no big deal the bulk of the work is already done with your MACRO.. Once again, Thanks. You are a life saver.