Formula for line numbers to change with existing formula

I am using the employee absence tracker template (Excel) and am having a difficult time when I add employees. The line numbers don't change in the formula and everytime I change the numbers to coincide with the line an error. I have 40 employees I want to add to this existing template. I actually added everyone and then errors started popping up everywhere. I am not real familiar with excel and I thought this template would help make me look good .... but! Please take a look at the document and help me understand how this should work or if it will work. If you can get it to work, please add and I will be able to populate the months.

Thanks!

Hello Welcome to the forum. Is this you are looking for !!



If answer satisfies you please Click " * " at the left hand corner!!

Yes, exactly! How did you get the formula to change at each paste? And would I be able to add more rows if necessary without disturbing the calculations?

Thank you so much!!!

Vmgballer1, there is nothing to change in whole sheet as such. You just copy and paste with a difference of one cell in all the sheets and yes you can also add as much addition as you want. formula will update automatically everywhere.

If answer satisfies you please Click " * " at the left hand corner and mark thread as solved just go to thread tools and select solve.