Need help separating a project from 1 worksheet to 3 worksheets

Hello Forum,

I had gotten a great code from a member here, BSB, who solved my original issue but I made some changes to my project and could use anyone's help to make adjustments to the code.

In the attached workbook you will find everything works correctly as designed, where I type a number in the input cell and that will be the number of rows from the bottom of the Data Source Table to be duplicated to the top of a new range. You will also see it is all on one worksheet.

I would 2 adjustments which I can't figure out on my own.

1) To separate the parts onto 3 sheets: The Data Table on Sheet1, the input cell on Sheet2, and the new Range on Sheet3.

2) I would like to change the new Range to a Table but would need to have the empty rows that would appear from reducing the number in the input cell to be deleted so that the Table doesn't have any blank rows.

Any help with this code would greatly appreciated. Thanks so much!
-Maria

Your current code has problem when the user enters the number greater than the List rows. e.g. 22

To Sheet2 code module

Please Login or Register  to view this content.

Originally Posted by jindon

Your current code has problem when the user enters the number greater than the List rows. e.g. 22

To Sheet2 code module

Please Login or Register  to view this content.

Hi jindon,

Thank you so much!! This looks great and yes, I knew it had that issue but I thought it was something I just had to make sure not to exceed the data set but you fixed that too!! So awesome for doing that. I am really grateful for the help, much appreciated

You are welcome and thanks for the feedback.