O'Reilly logo

Excel 2010 Financials Cookbook by Andre Odnoha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Highlighting user edits and storing the versions

In order to gauge financial strength and create proper forecasting, it is necessary to collect data from multiple sources. Within that data collection, it is also necessary to provide datasheets to others. When sharing worksheets, Excel will allow you to utilize track changes to see what was edited; however, with regards to user functionality, this method falls short.

In this recipe, you will learn to create an add-in to an Excel worksheet that will not only track changes, but will also mark the changes to identify the location of the changed data and create a cell comment with the past values for easy reversal and historical tracking.

How to do it...

We will start by opening the Visual Basic Editor ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required