Simple Excel VBA

1. Row 3 has random numbers that refresh every time "F9" is pressed 2. Cell B1 is an input cell for how many iterations i want to run 3. Starting in row 7 is pasted value data of one iteration of the data in row 3 I want a simple VBA code that will loop through a procedure to copy and paste value row 3 data determined by the number i put in cell B1. I also want to add a status bar at the bottom of the sheet that shows that you are on iteration "1 of 50" or whatever corresponds to cell B1.