The following has VBA code checks the daily input and corrects any invalid entry e.g "c25C25" is changed to "C25,C25"
The code is Sheets "WEEK1" and "WEEK2" (already done for you)
FYI:
Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Press Alt+F11 to open the Visual Basic Editor
Double click on Sheet "Calculations"
Paste code into blank area on the right
Close the VBEditor
Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
[B][I]
For each day in each week there is named range "(Wk1_Day1_rng", "Wk2-Day1_rng" etc)
ENTER data in WEEK1 or WEEK2 so formulae in "Calcultations" are not overwritten
Bookmarks