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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Help with column accumulation needed 2
How to find duplicate column (not the cell values) 3
how to compare formula's values? 4
Averageifs - criteria is cell is not blank 1
Need excel copy a row and automatically insert new rows based on a cell contents 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
How do I sort data in column B to align with data in column A? 1

Top