Replied to Sheets Tip 199: IMPORTRANGE Backlink To Source Sheet (ckarchive.com)

Now, what about going the other way? From the destination Sheet back to the source Sheet?

Providing a backlink to source sheet is a nice addition to the tool chest:

=HYPERLINK(REGEXEXTRACT(FORMULATEXT(A2),"""(.+?)"""),"Source "&CHAR(8599))

The post 💬 Sheets Tip 199: IMPORTRANGE Backlink To Source Sheet first appeared on Read Write Collect.