elsuji
09-28-2019, 10:12 AM
Hi
I am writing formula for cell value one sheet to another sheet.
For example i want value is copy from sheet1 C5 to Sheet2 D6. For that i am writing =Sheet1!C5 on Sheet2 cell D6. The value is updating ot the tile of writing this formula. But after that when ever i am changing the value on Sheet1 C5 it is not updating Sheet2 D6 automatically. i want to update it manually or while opening the wrokbook it is updating.
Can any one please help me how to update this automatically when ever i am changing the value on Sheet1 C5.
I am writing formula for cell value one sheet to another sheet.
For example i want value is copy from sheet1 C5 to Sheet2 D6. For that i am writing =Sheet1!C5 on Sheet2 cell D6. The value is updating ot the tile of writing this formula. But after that when ever i am changing the value on Sheet1 C5 it is not updating Sheet2 D6 automatically. i want to update it manually or while opening the wrokbook it is updating.
Can any one please help me how to update this automatically when ever i am changing the value on Sheet1 C5.