Insert Rows and Copy Last Line Entered Into New Rows

Hello all,

I posted a similar request yesterday (thanks for the help DBY) but have found I need to change my approach.

I have a spreadsheet where one employee enters data in to one row, then another employee will insert X number of rows depending on sample size, but the data from employee #1 does not get copied in to the inserted rows.

What I'd like to do is have a userform for employee #2 that they can enter the number of samples, click the command button, and it will insert the rows needed (number of samples - 1) and then copy the data that employee #1 had entered into those newly inserted rows.

I've attached a sample workbook showing what it would look like after a first and then second entry have been made.

Thanks for any help!