I have included a workbook. The final tab marked "TOTAL" will be for viewing purposes & shouldn't be included in any subsequent formulae that may arise. As far as current data in the workbook, everything is to remain as is; id est, nothing is to be taken away. I shall do all the hard work if someone can show me one example on which I can expand.
I need a validation that will not all any cells to populate until all previous dates' cells are populated. In the attached file, I purposefully left cell B7 in Sheet S1 blank for this. I need it where, if one tries to populate any cells for date "Thursday, January 07, 2016" across all sheets S1:S6, a stop message will alert one to fill all previous dates' cells before one can proceed. It will then apply for "Friday, January 08, 2016" across sheets S1:S6 et cetera. I hope I have explained it well. Again: I just need one example on how to do it, so I can learn it. Thanks in advance, everyone! :D Microbiology Daily Tally 16.xlsx