Hello. I have a macro that is triggered when one of three options in a dropdown is selected. The first option changes a cell value to zero. I need to figure out how to bring the last value that was in the cell the last time one of the two other options was selected. For example if the cell value was 50 when option B was chosen, then when it changed to option C, the value of that cell remained 50. Then when option A was chosen, the value changed to zero. I need a way to change it back to 50 (or whatever the value was) when options B or C are chosen again. I know this is as clear as mud but I'd appreciate any help. Here's the code I've been trying:
[pre]
[/pre]
[pre]
Code:
Sub ChangeIt()
'
' ChangeIt Macro
'
Range("C20").Select
Selection.Copy
Range("I54").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
If Range("C3") = "Option A" Then
Range("C20").Select
ActiveCell.FormulaR1C1 = "0"
End If
If Range("C3") <> "Option A" Then
Range("I54").Select
Selection.Copy
Range("C20").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End If
'
End Sub