Create multiple copies of a specific sheet in a WB based on a number in a cell

[thedoccontroller]

So... I need to copy the sheet pointed out below, the number of times indicated in the range circled. No specific renaming needs to happen. Can just be Brkr Form(1), " "(2),...etc or even sheet 1, " " 2... etc.

Just need them created so that when they print "all", they get the right number of copies of that sheet.

I'm open to other routes to get to this, but this seems like the simplest way yo get there.

Any help on this would be super appreciated.

 

[Fluff]

How about

Sub thedoccontroller()
   Dim i As Long
   
   For i = 1 To Range("H14").Value
      Sheets("Brkr Form").Copy , Sheets(Sheets.Count)
   Next i
End Sub

 

[thedoccontroller]

How about

Sub thedoccontroller()
   Dim i As Long
  
   For i = 1 To Range("H14").Value
      Sheets("Brkr Form").Copy , Sheets(Sheets.Count)
   Next i
End Sub

Hey Fluff, tnx for getting back to me. I apologize for not adding the range for the reference number of copies. Will this work if I have a range merged to put the # in? I guess I could set a hidden cell up to pull that number into and just reference that cell, right?

 

[Fluff]

Will this work if I have a range merged to put the # in?

Best way to find out, is to try it.

 

[thedoccontroller]

Hey Fluff, tnx for getting back to me. I apologize for not adding the range for the reference number of copies. Will this work if I have a range merged to put the # in? I guess I could set a hidden cell up to pull that

Best way to find out, is to try it.

Actually, you genius, you... It worked like a charm! Thank you soooo much. This is brilliant??

 

[Fluff]

You're welcome & thanks for the feedback.

 

[smozgur]

I switched the marked solution to the obvious answer post in this thread.

@thedoccontroller - in the future, please mark the post as the solution that answered your question instead of your feedback post. It will help future readers to find this question and its solution faster.

 

[thedoccontroller]

I switched the marked solution to the obvious answer post in this thread.

@thedoccontroller - in the future, please mark the post as the solution that answered your question instead of your feedback post. It will help future readers to find this question and its solution faster.

OMG... I'm so sorry! that was not what I meant to do. Thank you for catching that.?