Previous Topic Next Topic

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

Closed
Aswinraj - Jul 4, 2016 at 03:32 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 7, 2016 at 11:32 AM
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..,
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jul 7, 2016 at 11:32 AM
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
0