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.