Automatically copy the value of a cell
Solved
mj1974
Posted messages
2003
Registration date
Status
Membre
Last intervention
-
mj1974 Posted messages 2003 Registration date Status Membre Last intervention -
mj1974 Posted messages 2003 Registration date Status Membre Last intervention -
Hello,
First of all, thank you for reading me.
I created a workbook called "account 2015".
This workbook consists of 13 sheets: January, February, etc. and the last one is called "Forecast".
The 12 months consist of Debit and Credit.
The "Forecast" sheet contains all incoming and outgoing amounts.
When I enter a value in the "Forecast" sheet, I would like this value to automatically copy to each sheet.
For example: When I modify the amount of "Rent" in "Forecast", I would like this value to change for all months.
I previously saw that I had to click on the target cell, then type equals and then click on the target cell and confirm.
It works, but how do I select multiple target cells before confirming the source cell?
Thank you in advance.
Configuration: Windows 7 / Firefox 36.0
--
"I can accept failure, everyone fails at something. But I can't accept not trying."
First of all, thank you for reading me.
I created a workbook called "account 2015".
This workbook consists of 13 sheets: January, February, etc. and the last one is called "Forecast".
The 12 months consist of Debit and Credit.
The "Forecast" sheet contains all incoming and outgoing amounts.
When I enter a value in the "Forecast" sheet, I would like this value to automatically copy to each sheet.
For example: When I modify the amount of "Rent" in "Forecast", I would like this value to change for all months.
I previously saw that I had to click on the target cell, then type equals and then click on the target cell and confirm.
It works, but how do I select multiple target cells before confirming the source cell?
Thank you in advance.
Configuration: Windows 7 / Firefox 36.0
--
"I can accept failure, everyone fails at something. But I can't accept not trying."
2 réponses
Hello
If all amounts are in the same place across the 12 monthly sheets, for example the rent in B3, click on the January tab, then hold CTRL and while keeping it pressed click on the last tab December, and select B3 where you enter = and then select the source cell in Forecast
Best regards
--
"Imagination is more important than knowledge." A. Einstein
If all amounts are in the same place across the 12 monthly sheets, for example the rent in B3, click on the January tab, then hold CTRL and while keeping it pressed click on the last tab December, and select B3 where you enter = and then select the source cell in Forecast
Best regards
--
"Imagination is more important than knowledge." A. Einstein
Thank you very much, it works.
Have a nice evening.
Best regards.