I'm looking for a way to use an InputBox to ask the user how many of X objects they have. If the answer is 4 for example - the macro should take action and select a certain range like A15:A20, copy those rows and then insert them as many times as chosen in the InputBox below that range. In this case it would insert 20 Rows starting from A:21 and preferably leave a space between each one.
Anyone can help me with this?
Thanks!
Bookmarks