Paste a range X number of times based on InputBox Value divided by 4

[kierstin]

This is what I'm trying to do:

Please Login or Register  to view this content.

I have attached a copy of the workbook that I'm creating this for. Any help would be greatly appreciated.

[BeachRock]

Hi Kierstin,

I'm not sure if this will help or not but thought I would offer it with the off chance it could be of some use. In the example below, the Cell B1 has a data validation list of numbers 1 through 150 and is used to tell the macro how many times to insert a new record with the same copied information and is activated by a button. See below:

Please Login or Register  to view this content.

[kierstin]

Thank you, Tony. I never thought of using a data validation list. I will give it a shot.

[arlu1201]

Question posted in Commercial services hence closed.