User Profile
Ytimynona
Copper Contributor
Joined May 08, 2023
User Widgets
Recent Discussions
Re: Changing reference cells without changing data
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.1.1KViews0likes0CommentsChanging 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 project for a few months whose name I wish to remove from the list. How do I pull her name from the list without changing the list of every task she did prior to her reassignment? (Without copy pasting every previous cell of the worksheet into itself without formatting.) I've tried locking (the formula was still there, so it still changed all my old cells when I removed her from the list) and freezing (which didn't help at all), but neither did what I wanted.1.3KViews0likes4Comments
Recent Blog Articles
No content to show