| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Save value of cell prior to change
is there any way to save the value of a cell into another cell if the cell is
updated? If A1 has a date (01/01/09) and that date changes (02/01/09)I want to save the previous value (01/01/09) in K1. This repeats on 4 cells within the row and multiple rows. thanks, Rick |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Save value of cell prior to change
Tight-click the sheet tab, select view Code, paste this in:
Dim WasValue Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then Cells(Target.Row, 11).Value = WasValue End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column = 1 Then WasValue = Target.Value End Sub Bob Umlas Excel MVP "Rick" wrote in message ... is there any way to save the value of a cell into another cell if the cell is updated? If A1 has a date (01/01/09) and that date changes (02/01/09)I want to save the previous value (01/01/09) in K1. This repeats on 4 cells within the row and multiple rows. thanks, Rick |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Save value of cell prior to change
Make that Right-click, not Tight-click
:-) "Bob Umlas" wrote in message ... Tight-click the sheet tab, select view Code, paste this in: Dim WasValue Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then Cells(Target.Row, 11).Value = WasValue End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column = 1 Then WasValue = Target.Value End Sub Bob Umlas Excel MVP "Rick" wrote in message ... is there any way to save the value of a cell into another cell if the cell is updated? If A1 has a date (01/01/09) and that date changes (02/01/09)I want to save the previous value (01/01/09) in K1. This repeats on 4 cells within the row and multiple rows. thanks, Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I run a macro upon saving a file but prior to actual save? | Excel Discussion (Misc queries) | |||
| accidental save - recover prior version of Excel file? | Excel Discussion (Misc queries) | |||
| I need to change cell string lenths prior to upload into sql table | Excel Worksheet Functions | |||
| Checking Client Status Prior to Save | New Users to Excel | |||
| How do I recover excel document prior to auto-save? | Excel Discussion (Misc queries) | |||
Linear Mode
