Hey guys. I am tracking use of non-inventory items for a business, mainly bags. I have attached my work here and want to see if there is a way of locking certain cells that are referencing functions in the top two tables from changing when the numbers in the tables change based on a physical count twice a week.

Here is a brief explanation of the sheet attached:

The In-Store boxes column (B11-B13) is what will change twice weekly. I will physically have a count done of the boxes we have on hand. Cells B3-B5 are just those boxes listed previously multiplied by 250, the number of bags per box. Now, B20 is the baseline count. It is the first count in the process and therefore should remain locked forever. But it is a reference to cell B3. Once I do a second count, B11 will change causing B3 to change causing B20 to change. I want B21 to reflect the change in B3 after the count on April 14 but I want the value in B20 to remain the same so I can create a graph that shows or trends. Is this possible? Is there a way to lock just the values in B20 (and C20 and D20)? Then I want the graph to the right (which will turn into a line graph) to reflect each new data set I enter. For this, I could just manually extend the graph's area of data pulling to BXXXX-DXXX.

Thanks for your help,

Matt

Bag Tracker.xlsx