Below is a snapshot of the Web page as it appeared on 4/10/2024 (the last time our crawler visited it). This is the version of the page that was used for ranking your search results. The page may have changed since we last cached it. To see what might have changed (without the highlights), go to the current page.
Bing is not responsible for the content of this page.
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.
I think the best way to do what you want to track historical data is to track your data like you are doing from cells b19 and down. then you can have your chart area in B10:b14 look up the last value for that list.
You can look up and chart your data using the offset formula:
Bookmarks