Copy Row based on Column

[Guest]

Using VBA, I need to copy a row from column B through K once text data is
input into column K from that row. I need the data copied from the sheet
named “EMS†to the first sheet named “EOCâ€. The copied data would be placed
in the last row in columns B to K of the EOC Sheet.

Is this possible.

 

[Ron de Bruin]

Try this
http://www.rondebruin.nl/copy1.htm

This one
http://www.rondebruin.nl/copy1.htm#ActiveCellrow

 

[Ron de Bruin]

I forgot

You can use a event to run the macro

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 11 Then
MsgBox "yourmacro"
End If
End Sub

See
http://www.cpearson.com/excel/events.htm