Copy 10 sheets (along with data) into new 10 sheet in Same excel [Closed]

Report
-
Posts
2761
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2021
-
Hello,

I have an Excel which contains 10 Sheets with data.., Once a Go button is Clicked it new 10 sheets should be opened in same Workbook along with the data.

Please help me..,

1 reply

Posts
2761
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2021
462
Hi Answinraj,

To do that:
- right-click 1 of your sheets tab
- click on "Select all sheets"
- right-click 1 of your sheets tab again
- click on "Move or copy ..."
- check the "make copy" box and click OK.

When you want to link these actions to a button, start recording a macro and take the above steps, then stop recording. Now you can "Call" the macro in the button script.
Like this:
Private Sub CommandButton1_Click()
Call Macro1
End Sub


Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!