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?

Paul Newcome

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.

Cory Griffis

That's exactly what I needed. Thank you!

Paul Newcome

Happy to help.