Forum Discussion
Changing reference cells without changing data
I have a sheet that auto assigns a task to workers, in order, using a basic index and Vlookup. The list of workers is in a different sheet. I have a worker getting pulled to work on a special pro...
Perhaps you may share small sample file removing sensitive information to illustrate the question.
I'll grab one now. How do I attach? As screenshot or actual file?
Better as actual file. If you can't attach it to the post please share on OneDrive, GoogleDrive, etc.
- It won't allow me up upload a file, but I'll try to link it in Google drive!
https://docs.google.com/spreadsheets/d/1n_YX92QuuNGGrFykWrBZCKII0lzuIXKr/edit?usp=drivesdk&ouid=112947878337329981099&rtpof=true&sd=true
I want to remove user B and ensure no further files are assigned to her, without removing the fact that she was already assigned tasks 1 and 7.