Welcome to Mr. Excel!
So is this how you have it? You had the original values in cells
B3:D5 in sheet
1. You then went to sheet
2, clicked on cell
B3, pressed the =, went back to sheet
1, selected cells
B3:D5 and pressed enter . . . to give you the formula in cell
B3 in sheet
2 to be:
If so, you will find that if you recalculate sheet
2 (shift and F9 keys), it will update changes that you did to sheet 1.
If this is what you want, but you don't want to keep doing this manually,
- Right click on sheet 2's tab at the bottom.
- Select View Code
- Copy the following code into that window.
- Close that window.
- Save your Excel Workbook as with the file extension .xlsb instead of .xlsx.
VBA Code:
Private Sub Worksheet_Activate()
ActiveSheet.Calculate
End Sub