Forum Discussion

farazpro's avatar
farazpro
Copper Contributor
Apr 25, 2024

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

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.

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Then only option to use VBA coding. You can write codes to sheet_change event.