Forum Discussion
Jarvo
Oct 07, 2021Tin Contributor
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...
- 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
SergeiBaklan
May 03, 2023Diamond Contributor
If apply formatting by Format Painter?
Manoj_AI
May 03, 2023Copper Contributor
SergeiBaklan
It has to be updated automatically whenever I add or delete the rows. For ex. I have a 5 groups with Dark blue and then in each group, I have 5-10 subgroups with Light Blue. So whenever I add or delete the Group or Sub-groups the colour formatting of them has to reflect in the mirrored table too.