View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ann ann is offline
external usenet poster
 
Posts: 210
Default Rollup worksheets into a master worksheet - automatically?

I would like to have three different people update their own product
lines within a master workbook. The master worksheet needs to retain
sorting ability. Is there a formula or macro I can use to pull this
information from three individual worksheets into the master workbook,
based on the user name? The master worksheet would then become "read
only".

* All column headers are the same
* The workbook would contain these worksheets: Master, Cathy, Laura,
Tonya

Thanks for your consideration.