troubleshooting Question

Find and move row

Avatar of Seamus2626
Seamus2626Flag for Ireland asked on
Microsoft Excel
2 Comments1 Solution191 ViewsLast Modified:

Im looking for a sub that can search down Column N in tab "Raw Data" and if it finds a returned item (i.e. not blank or #N/A) it will then select that row from A:J and copy and paste to the next available row on tab "Output"

I have attached an example file and highlighted the example in 'Raw Data' that would be moved to 'Output'

Join our community to see this answer!
Unlock 1 Answer and 2 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 2 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