sheet1 function

[Rich]

Hi all...In a workbook I use the function =SHEET1A1 IN
Sheet2 to copy everything I enter in column A in sheet 1.
But if I make a change later on in sheet 1 I DON"T want
the info on sheet2 to change. In other words at 1pm I
enter the word "download" in sheet1 A1 it is copied into
sheet2 A1. But if at 3PM I enter the word " upload" into
sheet1 A1 I still want sheet2 A1 to say "download". Thanks
for any help you can give.

 

[Frank Kabel]

Hi
this is not possible with formulas but would require VBA (e.g. using an
event procedure) Is this a feasible solution for you?

 

[Rich]

Yes it would be..what is the VBA code? Thank U

-----Original Message-----
Hi
this is not possible with formulas but would require VBA (e.g. using an
event procedure) Is this a feasible solution for you?

--
Regards
Frank Kabel
Frankfurt, Germany



.

 

[JE McGimpsey]

One way:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count > 1 Then Exit Sub
If .Column = 1 Then
With Sheets("Sheet2").Range(.Address)
If IsEmpty(.Value) Then .Value = Target.Value
End With
End If
End With
End Sub

 

[Rich]

Thanks... Appreciate the help

-----Original Message-----
One way:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count > 1 Then Exit Sub
If .Column = 1 Then
With Sheets("Sheet2").Range(.Address)
If IsEmpty(.Value) Then .Value = Target.Value
End With
End If
End With
End Sub







.