I am trying to set up a project tracker for my team at work to use. We want to have a Master sheet that contains all of the jobs, and then have individual sheets for each member of the team where their jobs can be pulled from the Master sheet. So the doc is laid out as:
- Master
- Person A
- Person B
- Person C and on and on...
We have this set up already with all of the information pulling through correctly. We also have a Notes cell in the Master sheet, which pulls all of the data from the individual notes cells in the individual sheets (this is using ='PersonA'!L6, or ='PersonA'!L6&'PersonB'!L12) to populate.
We can delete a row from the Master and it will be removed from the individuals sheet (great!) however, it's not deleting the notes cell from the individuals' sheet. So the data surrounding the row will move up in response to the row being deleted, however the Notes cell doesn't delete. This is causing the Notes cells to no longer correspond with the correct projects every time a row is deleted.
Hopefully the above makes sense!
Does anyone know if there is a workaround this?
