Extensive projects typically require many document revisions, and clients generally want to know what has changed since the last document issue. However, keeping track of Excel list modifications in a separate column is time consuming and prone to omissions and typos. Furthermore, the margin for human error is only increased when multiple users are involved in the list. This script eliminates the need for manually tracking changes, and improves the accuracy of the procedure by substituting manual input with automated computation. It compares the issued list with one to be issued and marks up the issued list with all new alterations. The single cell alteration is shaded grey, and the previous value is stored as a cell comment while the cell value is overwritten with the value from the new list.
The whole deleted row is shaded red, and text is crossed through
The new row is added at the bottom of the list and shaded grey