Dec 19 2021 11:42 PM - edited Dec 19 2021 11:51 PM
@tika2335 You can create a named formula, eg. called "result" where the formula is like this:
=EVALUATE(Sheet1!B2)
Then in B3, type =result
Note that the EVALUATE function is an old Excel 4.0 macro function. Your file needs to be saved as an xlsm file for it to work.
Dec 20 2021 09:33 PM
@tika2335 On the Formula ribbon, you'll find the Name Manager.
That's where you enter the named formula as demonstrated in the picture. I've attached the file.