Forum Discussion
farazpro
Apr 25, 2024Copper Contributor
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.
- Harun24HRBronze ContributorThen only option to use VBA coding. You can write codes to sheet_change event.