Forum Discussion
Copy a value in certain cell to others
Thanks but it doesn't work because it gives the value of zero to other cells that I want G2 value copied to them as well. So as shown in example I need the value of G2 in A1, A4 and A7, and I need it automatically updated when I change G2.
Thanks alot
Little Confused!!
You are requesting the value of G2 cell will automatically update in A1, A4 and A7 cell. but your attached file said, your value is in G1 cell. Any way
Based on the attachment file use these formula:
In A1 cell enter =G1
In A4 cell enter =G1
In A7 cell enter =G1
Based on your reply use these formula:
In A1 cell enter =G2
In A4 cell enter =G2
In A7 cell enter =G2
If the logic is as this better to use absolute references, more exactly in A1 is
=$G$2
and after that copy A1 and paste it into another cells (A4, A7, whatever) where the value of G2 is to be repeated.
Thanks a lot!
Sara Kaffashi i recommend the same of SergeiBaklan, put the formula
=$G$7
in the cells wherever you want.
Thanks guys it worked perfectly
