Recording the history of a cell’s value

Here’s the situation. You’ve got a spreadsheet where you’d like to track the changes to some cell values over time. Maybe they’re stock prices, or exchange rates or input parameters to a model. Whatever. But when you change the value tomorrow, you want a record of what that value was last week.The Curse of Excel’s Track Changes FeatureThe first […]