I am formulating an address list that I will ultimetely print address labels
from. I am forced to cut and paste this data from a online table. I paste
it into excel in the format below which represents just 2 records. Excell
provides me with the ability to massage this date thhrough a recorded macro
and bring the various rows into 1 row with several coloums. I can
sucessfully do this, however I want to automatically repeat this process
though 1500 records. How do I cause this macro to repeat from a conststant
starting point, that will execute this macro repeatetly.???

Smith1, KIMBERLY JUNE SL617162 Current, Inactive
Sales Associate 3/31/2008
413 NE 12 AVE POMPANO BEACH, FL 33060
Smith 2, SANDRA D SL3175798 Current, Inactive
Sales Associate 3/31/2008
2011 W ATLANTIC BLVD APT 308 POMPANO BEACH, FL 33069

Your help would be greatly appreciated!