I want Column B of Workbook 1 to mirror Column B of Workbook 2 - similar to Importrange in Google Sheets. Is it possible to do this between unrelated workbooks? Thanks in advance.
While we don’t support the ImportRange function, the best way to achieve this today is by using Related Rows with Related Row Lookups and Rollups.
More on Related Rows here:
…and Related Row Lookups:
We do have table syncing as a roadmap item in the future, which would more closely match mirroring columns from one workbook to another.