Extracting Data from Table By looping

Hello All!

What I am ultimately trying to do is extract data from many files within a folder. Within the files are "PlanNames", "IssueAge" "Duration" and "Factors." (Each file only has one plan name, but many issue ages and many factors) Each Factor represents another duration.

I am currently on my first file of 17,000+. So far I have this coding

Please Login or Register  to view this content.

It creates for me everything I need so far, but the factors. I am in dire need of a code that will read the row (A3:E3), (A4:E4), (A5:E5), and so on and then orderly place them into column J.
Advice would be greatly appreciated!!Macro.xlsm

The Code didn't work so well. But I have been working on it, and I've gotten this far:

Please Login or Register  to view this content.

I want to be able to do exactly what I did here but with the next set of cells for the next issuing age (11), and so on to 12, 13, 14, ....TerminalReserveMacro.xlsm

Duplicate thread. Please do not reply to this thread. See http://www.excelforum.com/excel-prog...y-looping.html