Running Macro With Loop

[Shawn1888]

Hello,

I'm trying to make a macro that will pull data from a reference worksheet, concatenate that new data, rename the file to the concatenated cell value, save the file, delete the reference worksheet row that has already been used, then run the macro again until the reference worksheet is empty.

My macro works for everything except for the loop. I can run it over and over manually and it works great, I'm just hoping to run it once and have it run 60+ times by itself.

Please Login or Register  to view this content.

Any help would be greatly appreciated. Thanks in advance.

[cubangt]

What determines how many times you need it to run?

[Shawn1888]

The reference worksheet has a finite number of rows with data. Running the macro pulls the data from row 2 of the reference worksheet to another worksheet, pastes the values and then deletes row 2 of the reference worksheet before saving the file. In essence, the reference worksheet values will move up one row every time the macro runs until there isn't any data in row 2 of the reference worksheet.

[cubangt]

Maybe give this a try: not tested.. but something to look at and see if it will help or work.

Please Login or Register  to view this content.

[Shawn1888]

I had to change the order of two parts of my code, but this appears to have worked perfectly! Thanks for your help, I really appreciate it.

[cubangt]

If it helped, consider adding reputation to the post that helped..and your welcome glad it helped.