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?
ASKER CERTIFIED SOLUTION
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