Copy a sheet from a workbook that updates
Solved
André Roussel
-
LaBoule2Petanque -
LaBoule2Petanque -
Hello,
I would like to know if it is possible to copy a sheet from one workbook to another and ensure that when we modify the first one, the second one also updates and changes accordingly?
And if so: how?
Best regards,
André Roussel
Configuration: Windows / Chrome 59.0.3071.115
I would like to know if it is possible to copy a sheet from one workbook to another and ensure that when we modify the first one, the second one also updates and changes accordingly?
And if so: how?
Best regards,
André Roussel
Configuration: Windows / Chrome 59.0.3071.115
3 réponses
Hello André Roussel
Yes, you can duplicate the sheet in another workbook, and then you will need to link the cells that will be modified.
To duplicate the sheet,
right-click on its tab and select copy/move
choose new workbook
and don't forget to check the box to create a copy.
For the links, both workbooks must be open.
In the new workbook, on a relevant cell, enter "=" and go to the other workbook, click on the corresponding cell, and confirm by pressing "enter."
This cell will take the value from the old workbook.
The two workbooks must be in the same folder.
Let me know if that works for you?
--
It is by forging that one becomes a blacksmith. - It is at the foot of the wall that one sees the mason - we always learn from our mistakes.
Yes, you can duplicate the sheet in another workbook, and then you will need to link the cells that will be modified.
To duplicate the sheet,
right-click on its tab and select copy/move
choose new workbook
and don't forget to check the box to create a copy.
For the links, both workbooks must be open.
In the new workbook, on a relevant cell, enter "=" and go to the other workbook, click on the corresponding cell, and confirm by pressing "enter."
This cell will take the value from the old workbook.
The two workbooks must be in the same folder.
Let me know if that works for you?
--
It is by forging that one becomes a blacksmith. - It is at the foot of the wall that one sees the mason - we always learn from our mistakes.
THAAANK YOU PHILOU10120 !!!!