Forum Discussion
Solved
How to mirror the column of a table onto a different table automatically
Hi everyone, I'm trying to set up a table (say table 2) that automically shows the contents from a specific column of a different table (say table 1). If a user randomly inserts a new row at any pa...
It is far more straightforward using Microsoft 365. There, all you need is a to convert the source data to an Excel Table and use a dynamic array formula to read the column you require across.
= Table1[Column2]Don't be tempted to add fields to the copy because they will not stay aligned.
I understand. Unfortunately the organisation I work for hasn't moved to Microsoft 365 yet, and is unlikely to do so any time soon!