View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
relpi98 relpi98 is offline
external usenet poster
 
Posts: 1
Default Macro Help - Updating Master List

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?