At Friday close the collection points have 18 and 24 items. The live sheet has =B2+C2 in D2, showing 42. The report needs the count as it stood on Friday.

Paste only the calculated value into the snapshot

Copy D2, select an empty cell on the snapshot sheet in Ulet, then choose Home → Paste Special → Values Only. Label it Friday close. The formula bar for the new cell should say 42 without an equals sign.

The live result from 18 plus 24 is copied to a dated snapshot.

Illustrated starting copy. The snapshot stores a number.

Test the two results with a temporary edit

In a spare copy change the live input from 18 to 19. The live total should become 43 and the snapshot should stay 42. Check any date, currency or percentage formats in the destination separately before distributing the snapshot.

Changing the first input to 19 increases the live total to 43 and leaves the snapshot at 42.

Illustrated independence check in a spare workbook.

Related Microsoft Excel reference