I have a Master List of contacts in 1 workbook that needs to be updated on a
weekday, daily basis from another workbook containing worksheets for each day
of the month. The daily worksheet and the Master List are identical:

A B C D E F G H I
J K
Status Co # Street City St Zip Source Product Result Next
Contact Date

I want to update A & K on the Master List automatically when data is changed
in the daily worksheets. Is there a way to do this automatically using a
macro?

Using the Worksheet_Change event might be a little too much activity in code
running, depending on how many changes occur during a given user input.
However, the Worksheet_Deactivate event would allow the update to occur
after changes are made and the user exits that worksheet. The code would
need to be in the sheet code module of the daily worksheets.

Private Sub Worksheet_Deactivate()
'Call the data transfer macro or code to do the transfer here.
End Sub


"relpi98" wrote in message
...
I have a Master List of contacts in 1 workbook that needs to be updated on
a
weekday, daily basis from another workbook containing worksheets for each
day
of the month. The daily worksheet and the Master List are identical:

A B C D E F G H I
J K
Status Co # Street City St Zip Source Product Result Next
Contact Date

I want to update A & K on the Master List automatically when data is
changed
in the daily worksheets. Is there a way to do this automatically using a
macro?