Forum Discussion
How to mirror the column of a table onto a different table automatically
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
I used this formula to mirror a table from one Excel sheet to another, but I cannot copy the table format from sheet 1 to sheet 2.
For Ex. I have the rows coloured in 2 different colours in the original table, but the mirrored table doesn't have any original formatting.Kindly advise.
If apply formatting by Format Painter?
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.
- This has done the trick wonderfully!
Thank you very much for your help
