We have a spreadsheet in LibreOffice calc that we use for estimation.
The cells on several different sheets [Sheet1, Sheet2, Sheet3] are in the following format:
Description (text), Estimate (numeric; drop down values restricted to 1,2,3,5,8), Experience (numeric; drop down values restricted to 1,2,3,4,5), Low (formula), High (formula), Full description (text), Solution (text)
Based on a user selection of Yes (it could be either drop-downs, radio buttons or check boxes) a number of cells (from 10-30 cells) in the Description column from another sheet [Sheet4, Sheet5, or Sheet6] will be copied into a specific sheet [Sheet1, Sheet2, or Sheet3], starting at a specific cell number (For example, A3).
To clarify, the Description cells should only be copied; all other fields will be left blank.
If the user selects No, the Description fields will be cleared in either Sheet1, Sheet2, or Sheet3. In other words, selecting Yes or No will only erase or overwrite the values in the specific Description cells; it would never erase values in any other cells.