sheet1 function

  • Thread starter Thread starter Rich
  • Start date Start date
R

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.
 
Hi
this is not possible with formulas but would require VBA (e.g. using an
event procedure) Is this a feasible solution for you?
 
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



.
Click to expand...
 
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
 
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







.
Click to expand...
 
Back
Top