| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| won't automatically repeat 1 item already entered in column? | Excel Discussion (Misc queries) | |||
| How to repeat cell downwards in a column? | Excel Worksheet Functions | |||
| Copy data in one cell to blank cell immediately below, repeat | Excel Worksheet Functions | |||
| I need to automatically repeat cell | Excel Worksheet Functions | |||
| in excel can one repeat the text from a the last used column cell. | Excel Discussion (Misc queries) | |||
Linear Mode
