r/excel • u/BehindAnElephant • 14h ago
Automatically copy formula from previous cell? unsolved
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.
1 Upvotes
1
u/floofytobles 10h ago
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.