Search Multiple columns for string, display matching results on different sheet.

[RichTea88]

Hey Guys,

Ripped this code from another site, it runs fine with no errors but never finds any results.
Tried tweaking it a couple of different ways to no avail. Anyone have any ideas how to get this to work? I just want to search columns A to E and display the matching Rows (columns A to F) on the sheet 'Search Results'

Please Login or Register  to view this content.

[ragulduy]

Please Login or Register  to view this content.

?

I just rewrote what you wanted to do cause the code you have doesn't look right, it seems as if the row/column reference in the cells calls have got mixed up.

[RichTea88]

Worked Great, Thanks Buddy!

[RichTea88]

Yudlugar,

I marked the thread as solved because you solved this problem. Can I ask one additional question?
How can I get the search results sheet to clear from row two downward each time I search?

[RichTea88]

Figured it out

Thanks for all your help anyways!

Please Login or Register  to view this content.