troubleshooting Question

Macro to search for text then copy and paste range to another sheet

Avatar of vegas86
vegas86 asked on
Microsoft Excel
4 Comments1 Solution539 ViewsLast Modified:
I have a spreadsheet that I would like to create a macro for, I have searched the internet and can’t seem to find what I would like.

What I would like is for the macro to search column I on sheet 1 for the specific text string “your name goes here”
When it finds the text string I would like it to copy that row and then 19 rows under that so 20 all up, I want it to copy the entire row not just a range and then paste the results one after the other down the page on sheet 2.

Can this be done?
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros