Hello!
I've got a small problem! I'm trying do create a simple excel sheet for my team where everyone will be tracking their hours for projects within an individual excel sheet. Lets call this sheet "Time Tracking". This sheet is structured in the following way:
The first column consists of a project on each row and for each column following the first one, there is a numbering of the day of the month on the first row. So if I've been working 8 hours the fourth day of the month on "project d" I will be looking in the first column for project a and the follow the columns until i find the fourth day of the month and add the amount of hours
The second Excel sheet is an excel sheet I call "Projects". The "Time tracking" sheet inherits its projects from the "Projects" - So the first column in the "time tracking" sheet is inherited from the first column of projects. The reason for this is that we want the name of the projects to stay consistent and control which projects are active and not.
Until yesterday, everything was working perfectly, but what happened was that I wanted to insert a new project in a specific row. So I opened up the "Projects" sheet, inserted a new row and added a new project, the "time tracking" inhertied this and the first column with projects was updated but... the other column did not move their added values to the next row.
For clarification, I have some projects a, c, and d, I wanted to add a project b in the same column as the other but in between the rows of a and c. So I inserted a new row between Project a and C in the "projects" sheet. The "Time tracking" document already have some values added to it and when the inserted row is inherited from the "Projects" to the "Time tracking" sheet, the projects C and D are moved down one row in the first column but theirs added values do not. Instead, the new Project B has the Project C values since they did not follow the project C to the next row.
I think i have to find a way to make the "Time Tracking" sheet inheret the inserted row but i do not know how!
Please help!
Bookmarks