Trying to create a button to save as new sheet and name Rota wc 12.12.12 (Date changes)

Hi Guys,
I was wondering if someone could help me out as i am sitting over this for about 4 days now and cant seem to find a solution.
I am trying to create a rota system where i have created a Source Page with Staff names and their hrly pay and a date range which is the data for my Master Sheet drop down box.
What I would like to do is chouse the date from the dropdown box and enter the rota on the master sheet.
Then I would hit my Save button and and it would create a copy of the master sheet and save it in a new sheet called Rota wc [the Date chosen from the drop box] . If someone could help me that would be great as i am a newbie to programming.

Thanks in advance

Have attached a copy of what i have so far.
Even if someone could just point me into the right direction, would be greatly appreciated.

hi have a look at this

http://www.ozgrid.com/forum/showthread.php?t=140933

Thank you so much, that's great

Please Login or Register  to view this content.

Hi Toonies,
Thank you so much for all your help so far, it's much appreciated.
I have attached the latest creation and it is working as i would like it to.
There is just one thing where i would like your ideas, its with the saving of the new sheets.
When saving the new same date twice it should give a message to allow an override of the existing file or to abort the task.
At the minute it gives me a error box (1004) but it will still save a new tab as Master (2) even if i click on end.
Also I changed the Date Range to only 1 year as otherwise it would be to many tabs. This also should make comparison easier then text format.

I am looking forward to your reply

Happy New Year

try this

NEWROTATEMPv1.xlsm

Hi Toonies,
just tried it and came back with the same error when saving the same file twice.
If you could have a look at the other sheet, I have tried to do it with Exit Sub but it might be in the wrong place.
Thanks

Soz posted wrong one by mistake

this should do it for you

NEWSTAFFROTATEST1.xls