2.1 Data Dictionary

Example of a DataDictionary

A user begins by specifying the name, type and allowed range (or values) for each variable. They then create a data entry sheet, by clicking the Create Data Entry Sheet button, which runs a macro to check that the dictionary is complete before generating a data entry sheet with data validation rules and conditional formatting.