Hi Ford
Thanks for your input. There are other elements of the operations scheduling project that rely on VBA control, not mentioned here as they are irrelevant. There are other things like "S" for sick or "H" for holiday that are included. Your method doesn't check anything other than the existence of an entry. However I do like it, as it would be simple and effective.
The data is captured from a master scheduler and imported as text, mainly "D/O" for day off but there are other text values as mentioned earlier, plus times in hh:mm format. The columns are actually Start/Finish/Early/Late.
I've attached a simple sample, showing most elements. The text inputs are manual for this example.
Please feel free to try out with VBA. Note: I don't want any formulae on the spreadsheet itself.
Many thanks!
Bookmarks