-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Changing Numbers
- Thread starter Wuddle
- Start date
phantom1975
MrExcel MVP
- Joined
- Jun 3, 2002
- Messages
- 3,962
WELCOME TO THE BOARD!
One way you can do it is with a macro. For example, if cell A1 has the data that changes. You can use this code:
Private Sub Worksheet_SelectionChange()
Range("A3").Value = Range("A2").Value
Range("A2").Value = Range ("A1").Value
End Sub
Then in cell A4 you would have:
=A2 - A3
This will show you the change. You can even use conditional formatting to change the colors.
One way you can do it is with a macro. For example, if cell A1 has the data that changes. You can use this code:
Private Sub Worksheet_SelectionChange()
Range("A3").Value = Range("A2").Value
Range("A2").Value = Range ("A1").Value
End Sub
Then in cell A4 you would have:
=A2 - A3
This will show you the change. You can even use conditional formatting to change the colors.
Upvote
0
