I have a unique complication for a nutrition tracker i built for Weight Watchers, and it could very well be one that is not resolvable the way I have it. Here is the scenario.

I have a column being totaled by a simple SUM equation in cell (E21)

I have a single cell (B20) that pulls the date and the output of that will only say the day of the week (Monday, Tuesday, etc..) Example (=TEXT(WEEKDAY(O23), "dddd"))

At the bottom of the sheet, I have a table for Monday thru Sunday. The current code in the cell next to each weekday, Monday (A40) for example, basically says if today's day (B20)=Monday(which A40 would be reporting if it is Monday), then the cell equals the sum from (E21). So all the input being totaled in my sum formula is being tracked for Monday, automatically.

Here in lies the issue. Once saved, and re-opened on Tuesday, the total obviously moves in my table to Tuesday because Monday’s formula becomes false, and Tuesdays becomes true. Or, if SUM data becomes deleted to start tracking a new day, of course, the information in the table goes away or becomes 0.

Is there a Macro or code I can use that will LOCK the sum in the table, so instead of code pulling the total, a MACRO will just lock the content of what the code equals and so now the cell is just a number?

I hope I explained what I wanted clear enough. It would seem I am asking for some sort of cell memory because I want to keep this as one page, to fit on an 8.5x11 sheet of paper if I need to print this.