data in 1 column/cell to automatically repeat in another cell/col

W

Warthog

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

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
 
Top