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.

hi,
an MVP may contradict me but i'm not entirely sure you can do what you want.
The worksheet change event fires the code each time a cell changes. you want
to copy an entire row but code would fire each time you enter something in a
cell. between b and k i think is 10.

as to coping to another workbook while someone else has it open - not
possible.
that would be a machine to machine/ memory to memory copy. not possible.

as a suggestion.
why not link the files through microsoft query.
in WB EMSLog.xls you could enter a row then save the file. this would put it
on a network disk. now the other user can get to it via MSQ.
in WB Consolidated EOC Log.xls, you could put up a button to fire the MSQ
which would retrieve the enties made and saved in EMSLog.xls.

yes i know. you want it to be automatic and my suggestion is a bit
machanical. sorry.
Any one else have a better suggestion?

Regards
FSt1

"Bill" wrote:

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.