If I write numbers in C4 sheet1 I want to copy

[Dag Johansen]

If I write numbers in C4 sheet1 I want to copy all in raw
C sheet1 to sheet 11 raw C. If nothing is writed in C4
nothing should happend. Is this possible and if so how to
do it?


Please help


Dag Johansen

 

[Don Guillett]

I assume when you said raw C that you meant COLUMN C.
right click on sheet tab>view code>insert this code>save workbook

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$C$4" Then Exit Sub
Columns("c").Copy [sheet11!c1]
End Sub

 

[Dag Johansen]

I got a error message "Run-time error 1004 application-
defined or object-defined error"

When I debug I get:"Columns("c4").Copy [sheet11!c1]" in
yellow.

Thanks

Dag

 

[Suresh]

Dag

Thats probably u dont have sheet11.Create it and should
work.
HTH

 

[Don Guillett]

--
Don Guillett
SalesAid Software
Granite Shoals, TX
(e-mail address removed)

 

[Myrna Larson]

Look at his reply again. It isn't supposed to be "c4", just "c".