View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anthony Anthony is offline
external usenet poster
 
Posts: 275
Default Link different worksheets in different workbooks to 1 master workb

Each employee has a workbook each with the same fields which they update, I
want to create a master workbook with all of the data from everyones sheets
which updates automatically when they make any changes? The fields will be
the same, im thinking this would be a complex lookup function??