I have data that has the names of employees on the A column and on the top of the rows are days. I have one sheet for every month.
The values where the rows and columns intersect are numbers with up to 1 decimal.
But in column C I keep a total of that month's values per employee.
In Column D I keep values for the past 6 months (Referencing a sum of the values of Column C for this and 5 previous months.
But, if I have to add or remove employees, I have to do it on every single sheet or it will throw off my formula and they will be referencing the wrong row that their data is on.
How can I avoid the work of adding and removing the agent from all sheets? What different formulas can I use?