how can i show value of one cell in another cell without writing the formula

Copper Contributor

i want to show values of cell 1 from sheet 1 in the cell 2 from sheet 2 without writing any formula in the cell 2 

for example : if the g30 cell is =sum(g1:g29) and i want the value to be shown in b10 in sheet 2 , i have to write (=sheet1!g30) in cell b10 to see the value of g30 in b10 , how can see the value of g30 in b10 without writing any formula in b10.

1 Reply
Then only option to use VBA coding. You can write codes to sheet_change event.