LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
automatically appending newly added data on worksheet to a master list worksheet tabylee via OfficeKB.com Links and Linking in Excel 0 December 17th 09 04:24 PM
Automatically copy from Master worksheet to others Susan S Excel Worksheet Functions 5 June 30th 09 01:08 AM
Automatically updating worksheets from a master worksheet Nlevans Excel Worksheet Functions 5 July 5th 06 03:41 PM
Master worksheet automatically enters data into sub worksheets Ken Excel Discussion (Misc queries) 1 November 1st 05 10:36 PM
Rollup worksheets into a master worksheet - automatically? Annabelle Excel Discussion (Misc queries) 0 October 18th 05 07:54 PM


All times are GMT +1. The time now is 06:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"