Running inventory count - even when clearing linked worksheet

Copper Contributor

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

1 Reply