1.Get the macro to move to a particular cell (the Range statement)
2. Fill that cell with a value
3. Store the value in a variable (call it x)
4. Move to the top of an empty column
5. Set up a loop to fill the column with x occurrences of your name
6. Fit the column width to the text (Autofit)
7. Get the macro to ask whether you would like to run again
8. Set up a statement which will go back to the start if you answer Yes