Forum Discussion
47states
Mar 26, 2023Copper Contributor
Running inventory count - even when clearing linked worksheet
This may be impossible. My son uses a spreadsheet with inventory counts. The inventory counts are linked to another worksheet for a particular customer project. He wants to be able to clear the customer project worksheet data after it has been completed and still have the inventory count keep a running tally on the master worksheet. Then he would use the customer project worksheet again and have the inventory subtract from the master worksheet. He wants it to keep subtracting the inventory from the master worksheet even when he c