Forum Discussion
Prevent data entry in cell if data already exist in workbook based on value of column A&B
We are using a spreadsheet to track employee time and absences. The workbook contains 4 similar sheets with the employee's number and name in columns A & B, respectively. Each sheet represents a di...
The workbook contains 4 similar sheets with the employee's number and name in columns A & B,
regardless of where they appear in the workbook.
why not consolidate 4 sheets to one sheet?
regardless of where they appear in the workbook.
why not consolidate 4 sheets to one sheet?
peiyezhu Mainly, it is a visual aid for each department, same as the final page that combines all the information for the manager. The reason they are not all in one is also due to the total number of employees, the different departments they are working in (each department needs the same tracking information, which is the first 26 rows of the sheets). The spreadsheet attached to this is just a small example for reference as I am not allowed to share the actual file outside of the company.
- prevent data being entered on the same day for the same employee
If you save in one sheet like
e.g.
date name department,
you can use countif or unique restrict in database to achieve your goal.
