macro to copy sheet to end with sheet name current date

Hi eugz,

Not sure why you'd create a tab for every day but this will do the job:

Please Login or Register  to view this content.

Regards,

Robert

Hi Robert. Thanks for reply.
Your code works awesome. But how to modify it to give ability for user change name in case if user will create some sheets at the same day? How to validate duplicate sheet name? Just inform user that sheet with same name exists and keep sheet name selected to give user ability to modify a sheet name

Thanks

Try this:

Please Login or Register  to view this content.