Copying cells from one worksheet to another.

[kiwi4444]

As you can see in the attachment there are two worksheets in the lower left corner. Worksheet and worksheet2; I'm trying to copying all the cells in the tab "worksheet" and copy them to "worksheet2".

How would I do that?

Thanks.


https://ibb.co/ibQPQq

 

[kiwi4444]

What is your ultimate goal here? What I'm trying to do is have 12 tabs; then have the contends of the 1st tab copied to each of the other 11 pages.

Are you wanting to make like 10 copies of the same Worksheet?
When you say multiple do you mean multiple copies of the same Worksheet. The script I provide which you never replied to will make a copy to the Worksheet and give it a new name.

Why would that not work?

We could write a script to Make 10 copies of worksheet named Me and give all the copies new names.

And doing it my way would also include all Buttons and other controls in the sheet. Not just the cell values.

Basically if it's not too much to ask for I would need ascript that can take the contends of the 1st tab (worksheet) and copy the contains in the 1st tab(worksheet) to each of the other 11 tabs(worksheets).

 

[Peter_SSs]

.. I would need ascript that can take the contends of the 1st tab (worksheet) and copy the contains in the 1st tab(worksheet) to each of the other 11 tabs(worksheets).

Try this.

Sub Copy_Data_v2()
  Dim i As Long
  
  For i = 2 To 12
    With Worksheets(1).UsedRange
      .Copy Destination:=Worksheets(i).Range(.Cells(1).Address)
    End With
  Next i
End Sub

 

[kiwi4444]

Thanks I figured it out thanks guys.

 

[My Aswer Is This]

Glad we were able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Thanks I figured it out thanks guys.