Copy Row based on Column
 

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.

Copy Row based on Column
 

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

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Bill" wrote in message ...
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.

Copy Row based on Column
 

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message ...
Try this
http://www.rondebruin.nl/copy1.htm

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Bill" wrote in message ...
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.