For Each Loop Macro

I have included a sample file with a basic example of an input and the desired output after the macro has ran. This list will be dynamic on the input tab Col A and Col C will only be around 4-5 lines long but I would want the macro to be able to handle more if needed in the future. Col B however will range from 1-75,000+ again would want it to be able to handle any size.

The basic idea is that the info in Col A&C will be duplicated for each entry in Col B. The data in Col A&C are paired so as in the example A will always be with X, B always with W, and C always with Z.

I get the feeling this can be done with a for each loop but i am having "writer's block"/"brain fart" in figuring out how to actually code it.

I am using Excel 2007 on Windows XP if you need that info.

All help is appreciated and please let me know if there is any more info you need.

Sample file.xlsx

Hello chad portman,

The macro below has been added to the the attached workbook. There is a button on the "Desired Output" to run it. It uses 2 For Each Next loops to create the "Desired Output".

While this macro works with your sample data, it may not with your actual data unless the following conditions apply...

1. There are no column headers used.
2. There is at least one blank row and column around the input and output data areas

Macro Code

Please Login or Register  to view this content.