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...
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.