We help IT Professionals succeed at work.
Get Started

Copy rows by VBA

Andreas Hermle
Last Modified: 2012-08-20
Dear Experts:

I wonder whether the following task can be performed by running a macro:

The macro is to loop through data records.

Whenever it hits an entry in Column C formatted Verdana 16, the macro is to copy that row along with subsequent rows until the macro hits another entry in Column C (formatted With Verdana 16) and paste these rows into its own worksheet. The macro is to loop until the last entry in Column C has been found (formatted with Verdana 16pt).

I have attached a sample file with a couple of examples and instructions/explanations.

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

Regards, Andreas

Watch Question
Project Engineer, Electrical
This problem has been solved!
Unlock 2 Answers and 12 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE