Copying and Pasting. My head hurts :(

Morning all!

I am having trouble with some coding, and would love some advice and help.

In the worksheet I am attaching, what I am trying to do is extract info from cells A:E and transposing them into columns G:J. For the purpose of what I want it to eventually look like, I basically copied and pasted the info in to cells M:P to illustrate.

This is the code I have come up with so far:

Please Login or Register  to view this content.

It gives me the information I need up to row 101, but I need it loop and gather the rest of the data for me. The biggest problem I am having is with rows 105, 125, 145, 165, etc. The purpose of those rows is to tell me the issueage and duration, that's it. How do I create a continuous working loop to have it look like columns M:P?TerminalReserveMacro.xlsm

Get the rows from the used cells.

Please Login or Register  to view this content.

Duplicate thread. See http://www.excelforum.com/excel-prog...y-looping.html