Can I dynamically update data from a single column into another sheet to reflect added rows ?
@Paul Newcome - Are you able to assist me in walking through linking a data column from a roster sheet to a project sheet? I have a site roster that can change on occasion (new sites added) and I want to add only the Primary Column name into a project sheet to show this new site as needing to be added to the project.
I already linked the initial locations via basic cell linking but because you can't cell link blank cells I need a formula that will populate new sites to my project sheet as they are added to the site roster.
Help Article Resources
Check out the Formula Handbook template!