LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Generating Master sheet from child sheets

Hi,
I have got 10 sheets which are with some data. These 10 sheets will be
worked upon by multiple users. All these sheets are having the same number of
columns and same column headings. I want to link all the data of these 10
sheets into a single Master sheet. My requirement is that master sheet must
contain the same column heading as the other sheets and all the rest of the
data from the 10 sheets. The 10 sheets can be protected from adding new Rows
or columns of its is needed. Please let me know whether this is possible. IF
yes then please let me know in detail how should I do it?

 
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
Updating indivudal sheets thru a Master sheet Bob Excel Discussion (Misc queries) 3 March 13th 08 04:46 PM
Moving data from master sheet to new sheets Midget Excel Worksheet Functions 8 May 8th 07 03:33 AM
Getting info from individual sheets into master sheet [email protected] Excel Worksheet Functions 4 November 21st 06 10:05 AM
Getting info from individual sheets into master sheet [email protected] Excel Discussion (Misc queries) 1 November 17th 06 05:24 PM
link between sheets get messed when master sheet is sorted Kt Excel Worksheet Functions 1 October 30th 05 12:24 PM


All times are GMT +1. The time now is 04:13 PM.

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

About Us

"It's about Microsoft Excel"