Do Until Loop

[Themd]

Dear all,

I have managed to successfully use a do until loop, however once finished, I would like it to move to the next row and do the same thing.

Appreciate any guidance.

Thanks,
Themd

Please Login or Register  to view this content.

[shg]

Welcome to the forum, Themd.

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.

[shg]

Thank you.

Can you post a sanitized workbook that shows what you're trying to do?

[Themd]

I have a dataset for each Name by rows. However the data is in intervals of three. It has been collected every three months. What I would like to do is to interpolate the cells between two periods for the whole row. I have done it for one row, but I think I need an addition to the formula to make it go to the next row and repeat the same thing.

Example is attached.

Thanks,
Themd

[shg]

Try this:

Please Login or Register  to view this content.

[Themd]

This is great thank you.

However, this is taking the first number and the last number and interpolating. My coding would do it between each number separately.

when you have. 1 5 5 7 2 4

I would like to be able to interpolate between 1 and 5, 5 and 5 so on...

is it possible to combine my coding with yours?

Thanks.
Themd

[shg]

Oops -- omitted Trend:

Please Login or Register  to view this content.

[Themd]

Sorry,

I got it. I was being a little bit lazy

Thanks for all your help,

Themd

[shg]

You're welcome. Would you please mark the thread as Solved?

[Themd]

Thanks. I'll do.