D
david s.
i have a workbook with 20 sheets, each one bringing forward information from
previous sheet. i want to allow data entry into a cell if it has no value
brought forward. each cell in the column range has a formula linking it to
the corresponding range in the previous month's sheet, but not all cells will
contain data. once the data, if any exists, is brought forward, there is a
possibility of data entry into the remaining cells in the column, which will
then be carried on to the next months sheet, and so on. on activating the
sheet, i want to scan the relevant cells and determine if there is
information there, and if so they will remain locked, but if a zero value is
present, unlock them.
previous sheet. i want to allow data entry into a cell if it has no value
brought forward. each cell in the column range has a formula linking it to
the corresponding range in the previous month's sheet, but not all cells will
contain data. once the data, if any exists, is brought forward, there is a
possibility of data entry into the remaining cells in the column, which will
then be carried on to the next months sheet, and so on. on activating the
sheet, i want to scan the relevant cells and determine if there is
information there, and if so they will remain locked, but if a zero value is
present, unlock them.