Break Rota with VBA.

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.