Looking for the Lost code | Need Macro that can copy all rows to new sheet.

[shahao]

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 all columns, all matched rows should copy to a new sheet.

I had a code that I picked from the 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.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Looking for the Lost code | Need Macro that can copy all row to new sheet. - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[shahao]

I didn't get a solution there, that's why I posted my same question here.

 

[Fluff]

That doesn't change the fact that you must include links.