Forum Discussion
Copy a value in certain cell to others
Hello everyone,
I have a value in cell e.g. G2, and I have a certain cells in column in A where I need to have value of G2 copied! I know its a simple question but I can't find formula. The thing is that I need to update value in G2 so each time it automatically changes in columns in A2.
Any help highly appreciated
Sara
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
