Help with VBA Looping

Hey All,

I have to admit... its been a long time since i used excel VBA and I need some assistance if someone would be so kind to help me this evening!

I got a text file from a database and the info for each record is on 6 rows. Since the data is consistent all the way down, I created a macro with macro builder to save time to move the data exactly where i needed it for the first record... so that all the data i needed was on 1 line instead of 6, then in my macro i deleted the other 5 rows.

Now I am trying to remember how to loop this... and I cannot remember for the life of me the code i need to add to create the loop before and after the macro code. In short, I am shifting data around and because there will always be a indefinite number of entries, I need my macro to loop until there is no more data.

I won't bore you with the auto generated macro code because its sloppy and messy and I was trying to save some time by using the macro builder... LOL..

The first piece of data starts on Row2, column 3. Can anyone help me with a couple of lines of code? Any help would be highly appreciated.

DC

Ok Ok... i will bore you with the code... but remember... I did not hand write this.. LOL

Please Login or Register  to view this content.

You da bomb! That worked perfectly. I have never seen it done that way either...

I am very grateful for your help!

DC