ADRIANA P
asked on
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
but need have 10 more sheet the same as sheet 1
11 totals sheets
H_count_tool_to_11sheet.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Subodh Tiwari (Neeraj)
one question
if I rename the tab name from sheet 1 to other name
wont affect the working ?
one question
if I rename the tab name from sheet 1 to other name
wont affect the working ?
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
Also, here is a video demo about how to copy a sheet.
CopySheet.mp4
ASKER
Great Expert !
Great JOb !
working as needed
Great JOb !
working as needed
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.