Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Updating indivudal sheets thru a Master sheet | Excel Discussion (Misc queries) | |||
Moving data from master sheet to new sheets | Excel Worksheet Functions | |||
Getting info from individual sheets into master sheet | Excel Worksheet Functions | |||
Getting info from individual sheets into master sheet | Excel Discussion (Misc queries) | |||
link between sheets get messed when master sheet is sorted | Excel Worksheet Functions |