count number T 11

have this working as needed

but need have 10 more sheet the same as sheet 1

11 totals sheets
H_count_tool_to_11sheet.xlsm
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
To copy a Sheet follow these steps...

1) Right click on Sheet tab to be copied --> Choose Move or Copy --> Tick the CheckBox "Create a copy" and click OK.

2) Another method is, hold down the Ctrl Key, click and hold down the left mouse button and drag towards right, you will notice a + icon and then leave the Ctrl key and left mouse button.
After the sheet is copied, just rename it as per your requirement.
To rename a Sheet, double click the Sheet tab and rename it.
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Subodh Tiwari (Neeraj)

one question

if  I rename the tab name from sheet 1 to other name

wont affect the  working ?
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
No. The code relies on the ActiveSheet not on the Sheet name. So you can copy the Sheet1 and rename it as you want.

Also, here is a video demo about how to copy a sheet.
CopySheet.mp4
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great Expert !

Great JOb !

working as needed
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.