Forum Discussion
Copy a value in certain cell to others
Hi, after reading your request I understood that, you want a value in A2 cell which is same as G2 cell. If it is right then, in A2 cell use =G2. But fact is you wish to update G2 cell automatically and you do not mention any logic or anything by which we can help you with a formula to update your G2 cell value automatically. If you sahre sample data and the exact result you want in G2 cell then it would be fine to help you.
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.
