Select a range by user input to create templated workbooks from

I am hoping someone can help. I have put together the below code but I am now looking to include an option for the user to select the range of cells to generate a seprate workbook per row. Hopefully, via an input box that asks for the first row number and the last row number.

Below is the code I have so far:

Please Login or Register  to view this content.

Thanks for your time so far. So there is no way to pass a range through user input into the existing code. As the current code creates a template per line and saves each file with a naming convention. I have numerous entries and want to control how many lines are dealt with each time.

Sorry, I should try to be more specific. Ideally to generate a separate workbook per row. As the form I have above copies a row to a templated workbook and assigns a name based on the cells in that particular row.

Are you looking for something like this:

Please Login or Register  to view this content.

Exactly what I wanted thank you both for all the effort. The form works brilliantly well .

Is there a way of getting this macro to create a template per line based a column holding value 'y'?

Which column should be checked for the value 'y'? You can write an if statement inside the for loop to check the "y" condition, but we need to know which column.

Column A3 would be where I would put 'Y'.

Here is an update. Try on a test file, not tested.

Please Login or Register  to view this content.

Always amazing thanks. Such a small change, I wasn't uncertain what it was.

If that takes care of your original question, please select*Thread Tools*from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Thanks for Rep!