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
  • permalink
  • link
  • reddit
  • reddit

60% Upvoted

10 comments sorted by

View all comments

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.

1

u/floofytobles 9h ago

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?

1

u/BehindAnElephant 9h ago

They are in a table right next to each other.