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/AutoModerator]

/u/BehindAnElephant - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/NoYouAreTheFBI]

The formula to be copied...

So I assume this is a table and when you change the first cell in the table you want the rest to just update...

Highlight the table

Insert - Table

Write your formula in the cell, every cell within the column inside the table should autoupdate.

[u/Shiba_Take]

If you use Format as Table before making/editing formula it may happen.

[u/excelevator]

ctrl+d to copy the cell above

[u/BehindAnElephant → u/excelevator]

My bad. I wrote wrong. I want B1 to copy A1.

[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.