Forum Discussion

Jarvo's avatar
Jarvo
Copper Contributor
Oct 07, 2021
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...
excel
Formulas and Functions
Macros and VBA
  • PedroWave's avatar
    PedroWave
    Oct 08, 2021

    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

     

PedroWave's avatar
PedroWave
Brass Contributor
Oct 10, 2021

This topic refers to: How to mirror the column of a table onto a different table automatically

PeterBartholomew1, 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

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Oct 10, 2021

PedroWave 

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.

Resources