Extracting Data from Table By looping

[TexasBobcat]

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

[Bernie Deitrick]

Try this macro:

Please Login or Register  to view this content.

[TexasBobcat]

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

[LJMetzger]

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