This templates provides the fields that should be captured in a contracts register if you are planning on leveraging the advanced functionality of Excel:

 

See blog series here ->

[_/su_spoiler]

Overview
Contract fields and validation
Protect Your Data
Generate Unique ID's

[_/su_spoiler]

Download a pdf document showing the functionality of the QLD State Government contract and invitation document framework: 

 

Read the blog here ->

[_/su_spoiler]

Overview
Contract fields and validation
Protect Your Data
Generate Unique ID's

[_/su_spoiler]   Using Array Variable in Excel VBA to Boost Performance [_/su_spoiler] [_/su_spoiler]