0

Is there any function or other way that takes result of formula and pastes value to given blank cell without formula? It's quite annoying to use copy paste special->value or it's derivates. For example: A1=1

A2=2

A3=1+2

A4=function"paste special"(copy from "A3";paste value "A5")

A5=3

Improve this question
5
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    Commented Nov 16, 2022 at 10:14
  • Simple formula A5=A3 is not enough for you?
    – Akina
    Commented Nov 16, 2022 at 11:55
  • @Akina point of paste special->value is that it breaks connection between formula and result so the value doesn't change. If you use A5=A3 then changing any of the parameters A5 also is changing.
    – marsilt
    Commented Nov 16, 2022 at 12:34
  • 1
    If so then macro or VBA procedure seems to be the only option.
    – Akina
    Commented Nov 16, 2022 at 12:52
  • Using macros is a good approach.
    – Ceasar
    Commented Nov 17, 2022 at 3:01

0

Reset to default

You must log in to answer this question.

Browse other questions tagged .