Oct 07 2021 07:53 AM
Oct 08 2021 03:41 AM - edited Oct 08 2021 03:45 AM
Solution@Jarvo, try the attached file with this formula into the mirror table:
=INDIRECT("Fruits!" & $C$1 & ROW()-ROW($C$3)+1) & ""
Where $C$1 is a cell to inform a specific column: A; B;...
$C$3 is the cell of the mirror table header.
Regards,
Pedro Wave
Oct 09 2021 10:18 AM
Oct 09 2021 03:38 PM
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.
Oct 09 2021 06:11 PM
Oct 10 2021 12:15 AM - edited Oct 10 2021 12:18 AM
This topic refers to: How to mirror the column of a table onto a different table automatically
@Peter Bartholomew, with your solution using Excel for Microsoft 365, the dynamic array formula cannot be inside the mirror table, since dynamic array formulas are not supported in Excel tables. Therefore, one of the topic conditions is not met.
Not to mention that @Jarvo has told us that he doesn't have MS 365.
Regards,
Pedro Wave
Oct 10 2021 07:46 AM
True. The OP did not specify what they meant by a table, so I chose to assume an Excel 2007 Table with structured references, because that is what I use. Equally, I use dynamic arrays for calculation with very few exceptions.
As you suggest, it all depends on the tools you have available. I, for one, will never use a traditional spreadsheet again.