Change Roster values

Hi Bloodywog
The code in the attached has been modified to accommodate this

Having the ability to add more sheets without any errors. Maybe define only the sheets i require to update the roster? E.g. Overtime, Sick Leave, Personal Leave, Maternity Leave, Shift Swaps & Annual Leave sheets

It also includes stand alone procedures and a UserForm to do this

change individual records

You can use this feature or lose it...your option.
Let me know of issues.

Hi Bloodywog
Based on this

I be reading more into it tonight

I'm going to wait a few days until you've told me that what you have is what you want. We're already well beyond the scope of your original issue with the enhancements we've made. Mind you, I don't mind helping with the enhancements but we've been working on a moving target. Settle it down to where you want it to be...let me know when you've done that then post your file with the final structure...I'll look at it.

Hi

Sorry for making you work on a moving target.

This will be the last post regarding my issue.

I have highlighted in the sheet in yellow of changes that I require.
• I have insert a engine to work out roster automatically
• Menu sheet – The modify form is a Calender Icon to make a calendar pop up. I need the
code to insert it in date field.
• RecLeave sheet - I have from and to dates to insert in the roster. On the side I have the planner to show the dates
• Overtime - Can we these fields be updated from "OTSummary" sheet? So it continues down and updates the roster.
• CleaningRoster – Employee also have cleaning roster. Normally 2 employees clean but not always.
• OTSummary – I need to record all OT worked. When it’s setup, I like “Overtime” sheet to ref to this sheet.

I really do appreciate your help and time. I have learnt from your postings.

Hi Bloodywog
It'll take a bit to work through all of this...I'll get back to you.