Related rows link rows in multiple worksheets by acting like tables in a relational database – editing one changes the data in another.
You can create relationships with rows in any workbook you have access to, even workbooks in different folders. Related rows are a great way to connect data across multiple workbooks. For instance, if you have one worksheet to track job candidates, another to track job descriptions, and a third to manage interview scheduling, you can connect all three and make edits to data in one that will be reflected in the others.
Adam Steinfurth at LearnSpreadsheet.com has written an article and created a more detailed video about Related rows and Related row lookups:
For a more detailed introduction to Related rows, check out our Quick Start Guide article on Related rows and Related row lookups. Or dive into our full suite of articles on creating relationships between worksheets to learn more about these powerful features.