I need a way to create a macro that will populate a column with desired data,
but I need to the data to stop based upon where other columns end. Can this
be done?

Sample data provided below. I want to configure a macro to run and populate
the columns in front of the data using specific (never changing) data, but
the number of rows of data will be changing each time I use this workbook.

52605 08182005
20000 08202005
27459 08222005
36970 08242005
1181340 08222005
95700 08242005
59334 08242005
958102 08232005
12089 08272005
81026 08232005
28122 08182005
26247 08182005

Thank you,

Rick