I need some assistance. I have workbooks that are named and located as follows.

c:\operations\Consolidated EOC Log.xls
c.\operations\EMS Log.xls

I want to utilize the Worksheet_Change(ByVal Target As Range) of the EMS
Log.xls workbook so that when column J is updated that it copies the row
starting with columns B through K to the next available row in the workbook
title "consolidated EOC Log.xls" to the same columns B through K. Column A
should never be copied or populated.

Also €“ If possible I need the code to work while both workbooks are open by
different users.