How to create a source sheet that automatically updates other sheets if data is removed?
Our organization has roughly 150 program participants and we have a number of different sheets that have each participant listed as a row with various data in columns. I am curious if anyone has experience with creating a source sheet of contacts so that if I add/remove a participant from the source sheet, they get added to all subsequent sheets.
Currently part of our process when adding/removing participants requires us to go to numerous sheets and make sure they are removed so I am hoping to automate that if possible.
Any help is appreciate, thanks so much!
Help Article Resources
Check out the Formula Handbook template!