With the Validation Snip, you can indicate that data in a document is correct according to your personal judgment.
With DataSnipper you can cross-reference Excel with supporting evidence, like PDFs, images, MS Word and Excel files. The references are stored in the workbook. This makes it very easy to review audit procedures.
Setting a validation snip
- Click the Validation Snip button into active mode
- Select the cell that you want to link to the PDF
- Drag a rectangle around the relevant location on the PDF
- The tickmark that appears in the cell is now linked to the rectangle on the PDF
- Can you edit the tickmark entered in Excel when you use the Validation Snip?
When creating a Validation Snip, by default a green V will be entered in the Excel workbook. It is currently not possible to change the default tick mark. After you created the snip you can change the content of the cell, its color, font, and font size and this should not impact the link between the cell and the snip on the linked document.
Note that when you change a Text Snip to a Validation Snip, the content of the cell remains the same but the font color and cell color will change.
You can also use the “Find and Replace” functionality in Excel to automatically replace all Validation Snip contents at once.