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

i am adding clients names in colmn B and want that info to automatically
repeat in column Q. Anyone know the formula

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

in cell q2
=b2
copy down

or a worksheet_change event
right click sheet tabview codeinsert 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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Warthog" wrote in message
...
i am adding clients names in colmn B and want that info to automatically
repeat in column Q. Anyone know the formula