Insert rows based on user input from cell value in other sheet

Hello,

This is my first post here and I'm looking for a macro that will dynamically insert a specific number of rows based on the user's input to a cell that will be on a different sheet in the workbook.

Basically, I will have an initial column pre-filled with (date) formulas in each row. When I first build the column, I won't have any blank rows between the date-filled rows, but then I want the user to specify a numeric value "X" in a cell on a different sheet and then have the macro insert "X" number of rows underneath each dated row. It would need it to adjust the inserted rows dynamically whenever the user changes the "X" value.

I have included a sample sheet of data to show my expected outcome. I had to .zip it because it wouldn't upload as an .xlsx file for some reason. Thank you for any assistance!

That is perfect, except that it doesn't automatically update the rows if I change the input value. Do I have to use a button to launch it or is there a way to make it update dynamically? I'll see if I can find an answer before you or anyone else posts back.

Thank you very much!


EDIT: Nevermind, the button launch will work fine for this application. Thanks again for your quick help!

Perhaps this is an oversight on my part in explaining what I was looking for, but the macro does not remove any rows, it only inserts new rows every time it is run. I probably should have sad that I needed the macro to adjust number of new rows between the initial date lines up or down depending on the value set by the user.

However, I think I can live with having it just add new rows if I could also put in a second "Delete" macro to function the same way, using that same input value. It just needs to not delete my original dated rows and just the ones in between them.

Also, I'm now noticing some other unexpected behavior. The first time I ran it with "1" as the input value, it worked perfectly. But if I re-run the macro with the same input value of "1", then each successive time it runs, it add rows exponentially. The first time it added "1". Next time, it added "2", and the next "7", and so on. Yet, the input value remained "1". What is wrong?

Originally Posted by nilem

Maybe better to hide rows instead of delete/insert them?
See an example in the file.

That turned out to be a very good suggestion. It works very well and is probably a better fit for my project than delete/insert. My thanks to both you and mancubus for your kind assistance in taking the time to help me solve this, it is much appreciated!

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save