Jyggalag
Active Member
- Joined
- Mar 8, 2021
- Messages
- 445
- Office Version
- 365
- 2019
- Platform
- Windows
Hi all,
I currently have this setup:
I would like to have column E automatically paste column D, but as values. Right now column D is filled with the formula (=A+B). I would like to have this pasted as values into column E, but done so on an automatic basis.
The easiest solution I see would be to make a macro that pastes column D into column E.
However, I have seen some VBA codes that can do fancy tricks that might workaround this. For example, I remember seeing one that would turn a column into a subtraction/addition column, so if you inserted a number into this column, it would automatically subtract it or add it to the number in the next column.
Is it possible to do something similar to this, through a code for example? Where it sets column E to automatically paste the values from D into itself, preferably from cell E2 and downwards.
Would be amazing. Thank you everybody!
Kind regards,
Jyggalag
EDIT:
I essentially want Excel to run this VBA code, but at all times without me pressing on a macro:
I currently have this setup:
I would like to have column E automatically paste column D, but as values. Right now column D is filled with the formula (=A+B). I would like to have this pasted as values into column E, but done so on an automatic basis.
The easiest solution I see would be to make a macro that pastes column D into column E.
However, I have seen some VBA codes that can do fancy tricks that might workaround this. For example, I remember seeing one that would turn a column into a subtraction/addition column, so if you inserted a number into this column, it would automatically subtract it or add it to the number in the next column.
Is it possible to do something similar to this, through a code for example? Where it sets column E to automatically paste the values from D into itself, preferably from cell E2 and downwards.
Would be amazing. Thank you everybody!
Kind regards,
Jyggalag
EDIT:
I essentially want Excel to run this VBA code, but at all times without me pressing on a macro:
VBA Code:
Sub TestSumIf()
Range("E2:E8").Value = Range("D2:D8").Value
End Sub
Last edited by a moderator: