do while loop for range of cells

This isn't what you're looking for, but you did say "any advice is welcome."

I would have written your piece of code this way:

Please Login or Register  to view this content.

It does the exact same thing, of course, but as you can see, it's a lot, lot shorter.

If you put Application.ScreenUpdating = False at the beginning of your code, and Application.ScreenUpdating = True at the very end, your code should run instantly. What else do you have that's making it take so long to run?

Try this:

Please Login or Register  to view this content.

If desired, change the line that says Range(Cells(26, 6), Cells(26, 24)).Select and user variables for the cells, instead of the hardcoded numbers.

thanks for this! we're getting close to the solution

Please Login or Register  to view this content.

I added this part of the code, now it's adding the values in the correct rows (and not one singular row).

But currently they paste a formula, how can I copy the values? I tried following (but it doesn't work):

Please Login or Register  to view this content.

Solved:

Please Login or Register  to view this content.

thanks everyone for your input!