Hello, this is my first post in this forum. I am currently doing a mini attendance sheet for number of employees. I have two different sheets, "A" and "B".
In sheet B, there are a list of employees with each of them have 4 values (date).
In Sheet A, there are column of days of a month. I would like to mark "R" in the specific cell according from sheet B as shown for Employee 1 in the second picture.
My current formula for the cell in Sheet A is,
=IF(COUNTIF('B'!$E$5:$H$5,A!E$8)>0,"R","")
I would like to copy this formula down for Employee 2, 3, etc2 and the range in sheet refered change to according to the employee name.
I'm sorry if I didn't explain this correctly but whenever I pull down the formula from Employee 1, the range refered is still of Employee 1 and not Employee 2.
How can I make the range respond to the range Im pulling the formula to such as, Employee 2 in Sheet A will find if any date in the row include in range of Employee 2 in Sheet B.
In sheet B, there are a list of employees with each of them have 4 values (date).
In Sheet A, there are column of days of a month. I would like to mark "R" in the specific cell according from sheet B as shown for Employee 1 in the second picture.
My current formula for the cell in Sheet A is,
=IF(COUNTIF('B'!$E$5:$H$5,A!E$8)>0,"R","")
I would like to copy this formula down for Employee 2, 3, etc2 and the range in sheet refered change to according to the employee name.
I'm sorry if I didn't explain this correctly but whenever I pull down the formula from Employee 1, the range refered is still of Employee 1 and not Employee 2.
How can I make the range respond to the range Im pulling the formula to such as, Employee 2 in Sheet A will find if any date in the row include in range of Employee 2 in Sheet B.
