Primary sheet + secondary sheets

Hello,


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?

Best Answer

Answers