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...
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
This has done the trick wonderfully!
Thank you very much for your help
Thank you very much for your help