View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Annabelle
 
Posts: n/a
Default Update master workbook from individual workbooks

I have four users who update their own rows of data in a separate
workbook; each workbook layout is identical (columns are the same).
They are using separate workbooks because they need to be in and out of
the spreadsheet all day long and using a shared workbook only allows
one person at a time to enter and save their data.

I need to roll-up all rows into a master workbook that ALL users can
view. Understanding all workbooks will be on the same network drive, is
there a macro that will roll these workbooks into the master?