How can I make an Excel Macro do these steps? 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