Break Rota with VBA.

Unfortunately I can't!

My workplace computers are secure as we deal with sensitive information. Therefor we cannot email outside email addresses or share files to outside parties.

We track the breaks for staff between the hours of 0700 and 0000 HRS. So anything to automate this process rather than going along each staff member's row filling in the blanks and 1's would be great.

Sorry to be a pain!

Originally Posted by jeffreybrown

You are not being a pain, but if you don't provide a sample workbook, then in essence, you are asking somebody else to mock-up a workbook and then supply the answer.

The folks on this forum are excellent at providing answers, but not many want to mock-up your sample.

Note: take a quick read of the "yellow" banner.

I am going to work shortly so I will grab the workbook from work and upload it within the next hour.