troubleshooting Question

Copying cell contents into a blank rows

Avatar of Andreas Hermle
Andreas HermleFlag for Germany asked on
Microsoft Excel
5 Comments3 Solutions401 ViewsLast Modified:
Dear Experts:

I got a list of data records with blank rows in between at irregular intervals

For some specific reason I would like a macro to perform the following tasks:

As soon as the macro hits a blank row in the used range (A1:E138)
it will go up one row and copy the entries in Column A, B and C into the blank row located below.

The macro is to loop until it reaches the end of the used range (A1:E138)

I have attached a sample file for your convenience with a detailed descriptions.

Help is much appreciated. Thank you very much in advance.

Regards, Andreas

NorieSenior Associate
Join our community to see this answer!
Unlock 3 Answers and 5 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 3 Answers and 5 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