I am using a spreadsheet to keep track of inventory.
I have a cell (A) that contains the amount of inventory I store today,
I have another cell (B) that contains the amount of inventory I sold today,
I have another cell (C) that contains the difference, which is the NEW inventory.
I am trying to figure out how I can get the NEW inventory cell (C) to replace the old inventory cell (A) after I save a version.