| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Recording changed cells in the same sheet
What I need to do is this:
I have two column of data, the first has numbers and the second is blank. If I change anything in the first column I need the old value to appear in the second column automatically. What would be the easiest way to accomplish this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Recording changed cells in the same sheet
put in sheet code-module (column A1:A100 is target B is dest.) change if..
Dim x, cl Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("A1:A100")) Is Nothing Then Exit Sub Target.Offset(0, 1) = x End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) x = ActiveCell.Value End Sub "unlucky" skrev: What I need to do is this: I have two column of data, the first has numbers and the second is blank. If I change anything in the first column I need the old value to appear in the second column automatically. What would be the easiest way to accomplish this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Recording changed cells in the same sheet
That worked completely and perfectly. Thanks very much!
On Jun 12, 4:41 pm, excelent wrote: put in sheet code-module (column A1:A100 is target B is dest.) change if.. Dim x, cl Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("A1:A100")) Is Nothing Then Exit Sub Target.Offset(0, 1) = x End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) x = ActiveCell.Value End Sub "unlucky" skrev: What I need to do is this: I have two column of data, the first has numbers and the second is blank. If I change anything in the first column I need the old value to appear in the second column automatically. What would be the easiest way to accomplish this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sheet background color suddenly changed to light green from normal | Excel Discussion (Misc queries) | |||
| How do i recover original excel sheet that was changed and saved | Excel Discussion (Misc queries) | |||
| How do I make the Stop Recording bar pop up when recording macros | Excel Worksheet Functions | |||
| The columns names on my sheet have changed!! | Excel Discussion (Misc queries) | |||
| How do I have a macro format cells while recording? | Excel Worksheet Functions | |||
Linear Mode
