repeat if/then for multiple rows

Hello everybody, here is a brain teaser for you:

I am trying to repeat the same if/then conditional statement about 1000 times, each time using a different row. I would like to know if I have to manually enter each instance of the conditional statement or if there is a shortcut. The only difference is the rows that it is reading from and writing to. Here is the statement:

Please Login or Register  to view this content.

Basically, each cell referred to would be one row down for each instance. For example, if I was to type it manually it would look like:

Please Login or Register  to view this content.

As you can see, each number just increases by one. Is there a shortcut to typing each one out?

Many thanks in advance!

hello yayfalcor

Please Login or Register  to view this content.

you can use a for loop.
The code there is just a emaple that goes from sheet raw cells m1-10 and + 8 for the output range.
\
hopw this helps

this is untested

D_Rennie,

Very much appreciated sir or ma'am. I have the feeling this will do the trick. My only regret is that I cannot buy you a beer.

I'll try it out and let you know how it goes.

paypay accepts $100 bills.

glad i could help.

It worked beautifully.

Here is what I ended up with:

Please Login or Register  to view this content.

You saved me about two days of work! And the knowledge is priceless.

the amount ive picked up form this forum is incredible.
Just happy to be able to help.

Can you mark the post solved. Go to the 1st post click edit click advanced., There is a dropdown menu choose solved. save it.

Cheers again.