I have a "working days" Excel file with two sheets. In the 1st sheet I had three columns with type, surname and department (of employees), the days and date of the month. Below the days-dates columns, I "check" the days that employees are working with the number "1" (it could be a tick).
Is it possible, when I check in the sheet 1 an employee at a specific date with number "1" (or tick), to automatically fill, in the 2nd sheet, the data from type, surname and department in each column (sheet 1 B,C,D to sheet 2 B,C,D and E,F,G)?