Column insertion report from one tab to another

Solved
poupanano Posted messages 19 Registration date   Status Membre Last intervention   -  
poupanano Posted messages 19 Registration date   Status Membre Last intervention   -
Hello
I have a data table on one Excel sheet. The first columns of this table are replicated on another sheet. I want the line I insert on the first sheet to appear in the same location on the second sheet.
Thank you in advance for your help.

1 réponse

PHILOU10120 Posted messages 6463 Registration date   Status Contributeur Last intervention   833
 
Hello Poupanano

Select the tabs by clicking on the first one and then holding down the shift key while clicking on the last tab of the selection
With the sheets selected, insert the row in the desired location
All the selected sheets will have this row, you can insert formulas that will appear on all sheets
Click on a sheet to deselect the sheets

--
It is by forging that one becomes a blacksmith. - It is at the foot of the wall that one sees the mason - one always learns from their mistakes.
0
poupanano Posted messages 19 Registration date   Status Membre Last intervention   1
 
Thank you very much Philou10120
It works perfectly :-)
0