Copying values on table from one sheet to another using VBA

Vote count:

0

I have a master Table and number of other sheets. At the beginning of macro, i will decide how many copies to make out of the first sheet i have. Then, Each row on the master table will be copied onto the different sheets. So for example, row 1 on the master table will be copied to "Supplemental(1)" sheet and row 2 on the master table will be copied to "Supplemental(2)" sheet. and repeat until the number of sheets reached what i set at the beginning.

here is what i got so far

Sub Copier2()

Dim x As Integer


x = InputBox("Enter number of times to copy ")
For numtimes = 1 To x

    ActiveWorkbook.Sheets("Supplemental").Copy _
       Before:=ActiveWorkbook.Sheets("Supplemental")

   Worksheets("invoice master").Activate


Next

End Sub

can somebody help me with writing code for copy and paste off the master table?

asked 1 min ago

dave

1

Copying values on table from one sheet to another using VBA