How can I link a row from one sheet to another using the condition of a specific word?
I'm having trouble putting together an automatized cell linking formula.
The goal is to link an entire row from one sheet to another based on the condition that within a certain column there is a specific word. Each row with this word should be linked to the new sheet if possible.
Help Article Resources
Check out the Formula Handbook template!