I need code to copy values from row 1 of a sheet down to a specified number of rows. Please see sample attached. I need the data I enter from A2 to E2 to be copied 24 times (based on the value I enter in F2). The total count should include row 1, so basically it should be copied 23 times.
I don't know if there is a way to do this in Excel without a macro, any help would be appreciated! TIA.