3.9 Revising Data

3.9.1 Revising Ranges

If you need to change the maximum, minimum or allowed levels or codes for a variable simply make the changes in the DataDictionary sheet and click the Re-format Existing Sheet button. This will update the validation rules and conditional formatting to reflect the new ranges.

3.9.2 Revising Data

If you notice an error, this should be corrected in your file and re-sent to us with the date in the filename. This ensures all the data is correct and up to date.

Do not change the layout of the data entry table.

3.9.3 Adding a New Column

If you would like to add new columns to your data it is quite easy:

1. Add the variable(s) to the DataDictionary sheet
2. Enter a new name for the DataEntry sheet when prompted (maybe DataEntry2)
3. Copy the existing data from the original DataEntry sheet to your new sheet
4. On the DataDictionary sheet click Re-Format Existing Sheet
5. You can now enter data into your new sheet.