W Warthog Jul 3, 2008 #1 i am adding clients names in colmn B and want that info to automatically repeat in column Q. Anyone know the formula
i am adding clients names in colmn B and want that info to automatically repeat in column Q. Anyone know the formula
D Don Guillett Jul 3, 2008 #2 in cell q2 =b2 copy down or a worksheet_change event right click sheet tab>view code>insert this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column <> 2 Then Exit Sub If Target.row < 2 Then Exit Sub Target.Offset(, 15) = Target End Sub
in cell q2 =b2 copy down or a worksheet_change event right click sheet tab>view code>insert this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column <> 2 Then Exit Sub If Target.row < 2 Then Exit Sub Target.Offset(, 15) = Target End Sub
