Change Sheet that Cells Link to
Cory Griffis
✭✭✭✭✭
Hello Everyone:
I have an "Assigned To" column on a standard task list that is linked to a Project Directory. My goal is to be able to link the "Assigned To" column to the applicable role that is filled out in the Project Directory. I've gotten that to work, but the issue is that I need to duplicate both sheets for each project. Is there any way to update the sheet that the cells are linking to when I duplicate them without manually re-linking each cell?
Tags:
Comments
-
Try putting them both in the same folder, then save the folder as new. You should have the option of linking to old sheets or new sheets. Select new sheets, and you should be set.
-
That's exactly what I needed. Thank you!
-