Automatically copy formula from previous cell?

[u/BehindAnElephant]

I have tried google which only tells me =B1 will copy A1. This is annoying if I need to make a change down the road and have to go back to the original cell to copy the formula. I want the formula to more or less be copy-pasted automatically in B1 whenever I make a change in A1. Is this possible? It's in tables.

[u/floofytobles]

To clarify, you want the formula to update in B1, not just the value, but you want it to equal the formula in column A as if you had copied the formula into column B?

Can you give an example formula?

I'm not at my computer, but maybe there's a solution here with FORMULATEXT if anyone knows a way to get a string to evaluate as a formula.

[u/floofytobles → u/floofytobles]

If it is formula and not value, where are A1 and B1 actually? In your sheet, are they right next to each other as in your question, or are they more columns apart or even on different sheets?

[u/BehindAnElephant → u/floofytobles]

They are in a table right next to each other.

[u/BehindAnElephant → u/floofytobles]

I'd like B1 to automatically fill if there's a change in A1, C1 to automatically fill if there's a change in B1 and so on.

For example: I have in A1 [=A210%] and in B1 [=B210%].

If I change A1 to [=A215%] I'd like B1 to automatically change to [=B215%] and so on.

I have multiple sheets and it would be nice to not have to manually fill them whenever new information is entered.

[u/Solid_Text_8891 → u/BehindAnElephant]

It’s hard to tell if you’re referring to the values or the formulas in the cells. Please provide screenshots to get a better answer.