Excel de-reference cells

Question

I am trying to use a template I found on the microsoft website (link: https://templates.office.com/en-us/Employee-attendance-tracker-TM02780235). This is an employee tracker that I want to edit. When I enter a value under an employee, the value is referenced to other employees. For example, if I navigate to employee 1 and type 'd' in a cell, the letter 'd' will appear in the same cell for other employees. I would like to have the cells not reference each other, so when I type in the cell for one employee, it does not copy for other employees. Any help would be appreciated, thank you. 

Note: I have tried to delete fomulae, I have unlocked cells, but I cant figure out how to make that change. If this is difficult, I was wondering if someone could point me in the direction of creating a drop down menu in excel that way I could create my own attendance logger if the initial problem cannot be remedied.

Answer 1

I'm sorry, that is not possible.

That sheet shows what you setup in sheet "Employee Leave Tracker", and in there is no place for individual comments.

Andreas.

Answer 2

Thank you so much for the help but Im trying to achieve something in the picture below. 

Answer 3

You mean in sheet "List of Employees"?

First, widen the column width of column, the move the mouse cursor to the bottom right edge of the table till you see the NWSO arrow cursor, see screenshot below.

Now left-click and drag the mouse to the right, that widen the table. You can use that column for your comments.

Andreas.

Answer 4

That is not my intention, sorry for the confusion. For example, lets say I have employee 1; I would like to write a comment under a column, lets say employee 1 "achieved sales goal". This will show "achieved sales goal" employee 2 and so forth. I would only like the "achieved sales goal" to appear for employee 1, and be able to write something different in the same cell for other employees.

Answer 5

I don't understand why you want to enter a 'd' and where at all?

In sheet "List of Employees" you can customize the names of the employees.

In sheet "Employee Leave Tracker" you can choose the employee name in column B, then set a start date and end date, choose a leave type

Finally in sheet "Calendar View" you can choose the employee in C2

That's it. No need for a 'd' at all.

Andreas.