JeteMc: I took what you had said, and I tried to format it to my workbook, but it doesn't work. I REALLY want to learn how to do it. If I upload a similar file on which I am working, even if I have to manually change every cell, could you show me what to do? I know how to protect a sheet. I'm not worried about that. Sheet 7 is for viewing purposes only. I want the dates for the whole year to show, as indicated. Only the empty cells adjacent to the dates in Sheets 1 - 6 can have data. "Monthly" & "Yearly" totals (blue & green cells, respectively) cannot be manipulated; I'll lock those cells at the end. Remember: data cannot be entered for a date until a numerical value has been enter for the previous date. I'll do all the work if someone could steer me in the right direction. File: BOOK1_N.xlsx