That works really well with a little tweak here and there (cell range) so thanks!

I just have one more question. If I have more columns across the top how do I copy them over as well.

So (commas indicate columns)

JOE SMITH, A303, A505, N858, 788 Beverly Hills Ave, Los Angeles

Should Read....

JOE SMITH, A303, 788 Beverly Hills Ave, Los Angeles
JOE SMITH, A505, 788 Beverly Hills Ave, Los Angeles
JOE SMITH, N858, 788 Beverly Hills Ave, Los Angeles

You follow?

Oh, the counter doesn't seem to print on the new page either...but I think I can tweak it.