Duncs
07-14-2008, 06:38 AM
I have a spreadsheet into which staff are required to enter information. Some information must be entered, and where values are entered, other information must also be entered.
So, for example, I have the following:
In Columns A -> I I have the following headings:
Serial Num
Removed (Y/N)
Num Removed
Unit Cost
Removed By
Date Removed
Num Left
Reordered (Y/N)
Date Reordered
Staff would enter the serial number, and if a 'Y' is entered in column B, they must enter a value in Column C.
Similarly, if a 'Y' is entered in Column H, a value must be entered in Column I.
What I want to know is, without the use of a data entry form, is it possible to incorporate this kind of error checking in an Excel spreadsheet? Is it also possible to code it so that cells are greyed out if they are not required, coloured if they are, and flagged if they need an entry?
Duncs
So, for example, I have the following:
In Columns A -> I I have the following headings:
Serial Num
Removed (Y/N)
Num Removed
Unit Cost
Removed By
Date Removed
Num Left
Reordered (Y/N)
Date Reordered
Staff would enter the serial number, and if a 'Y' is entered in column B, they must enter a value in Column C.
Similarly, if a 'Y' is entered in Column H, a value must be entered in Column I.
What I want to know is, without the use of a data entry form, is it possible to incorporate this kind of error checking in an Excel spreadsheet? Is it also possible to code it so that cells are greyed out if they are not required, coloured if they are, and flagged if they need an entry?
Duncs