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.

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.

Illustrated independence check in a spare workbook.



