MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
Hi, I am looking for a macro code that can help me to solve my problem,
I have a large size of excel file with thousands of rows and multiple Columns, What I want If I search a specific text from the column, all matched rows should copy to a new sheet.
I had a code that I picked from this forum before, but I lost that, when a activate that Marco code a special search Box popped up, with pasting my required text all rows from sheet 1 copied to a new sheet.
If anyone that code please share it with me.
Thank you all.