Primary sheet + secondary sheets
I create a sheet of 20 columns, that i would call primary sheet. From this sheet, i create 4 secondary sheets which had 5 colums per sheet (5 * 4 = 20 columns) and which will be used by 4 groups of people.
So the primary sheet = 4 secondary sheets
Now i need two things:
- When i create a line or in the primary sheet, i need the 4 others sheets to be updated automatically with the informations of the new line created in the primary sheet,
- When the 4 groups of people update the secondary sheets, i need the primary sheet to be automatically updated with the informations of the secondary sheets,
Can you help me please?