Insert Rows and Copy Last Line Entered Into New Rows

[MDW12]

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!

[davesexcel]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[bakerman2]

Try this.

Please Login or Register  to view this content.