Forum Discussion

Copper Contributor

Mar 24, 2020

Set a cell equal to the formula in another cell and not its value

Hi, I have the following issue: I have a file with numerous sheets with the same data columns (different data). The final column is a formula column using the actual sheet's data for the calculatio...

excel

Formulas and Functions

VyHong

Copper Contributor

May 18, 2022

Herman86 Hi,

I got the same issue, I expect the entire column can apply formula from a cell as formula, not its value. So when I change the formula, the entire column will change as well.

Since you got help and figure it out how to acheive it, can you give me guidance how to do that?