For loop that pastes data using calculated row # and advances +1 column each time.

Worked like a charm! I almost had a code that would run it, but it wasn't looping to change the row #'s. Your code is much more condensed and does the same thing. Much appreciated!!

rylo, it's funny that you got me the answer for this. You helped me solve a problem using VBA almost 2 years ago. I was looking through old posts and saw where you had come to the rescue and provided me with the answers I was looking for.

Just wanted to say thanks again. I hope you continue to stick around because I know I'll probably need your help again in the future!

-Ryan