Copy Sheet named as current date with button VBA Excel

[AliceIoana]

I am trying to copy the first sheet once/click and name it automatically as current date.

first click is adding 2 sheets (10-Jun-21 & 10-Jun-21 (2));
Second click is adding Operator(2) & 10-Jun-21 (3);
third click is adding Operator(3) & 10-Jun-21(4);
When i click the button 4th time is adding one sheet per click (10-Jun-21(5)).
I don't understand why after the 4th click does what i want it to do. Here is my code. Thank you!!!

Please Login or Register  to view this content.

[mehmetcik]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[Mumps1]

Try:

Please Login or Register  to view this content.

[AliceIoana]

It worked. THANK YOU!! You are a life saver xD

[Mumps1]

You are very welcome.

[AliceIoana]

I have one more question.

I saw that for example if i use the button from the 3rd added sheet, it copies the 2nd sheet, which already has information in it.

is there a way to copy the main sheet? I am a beginner and i dont have much information to use

[Mumps1]

It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific sheets (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.

[AliceIoana]

First time I will click the button from sheet 1, which will remain the main page, unchanged (template if i can say).

after i introduce the data in second sheet(the copied one), i will press the button from there. And automatically will copy Sheet2, not Sheet1 as i want to.

so everytime I press the button, doesn't matter from which Sheet, I want to copy Sheet1, the main page.

I hope it makes sense

[Mumps1]

Try the following work-around:

Enter a value of 1 in cell AA1of the "Operator handover log new" sheet. This cell will be used as a "helper" cell to keep track of the sheet numbers and should never be deleted. Then try this macro:

Please Login or Register  to view this content.

[AliceIoana]

You are a god. Thank you so much for your help and TIME!!!

[Mumps1]

My pleasure.