Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating Master sheet from child sheets
Maybe you can use a macro ?
http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Sundar" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating Master sheet from child sheets
Thanks a lot for your help.
I saw your example and I feel that my task is almost done. But there is one minor issue I am facing. When I copy pasted the code into my VB editor and ran it I got an compilation error for the LAST ROW and LAST column. Its saying that the Function not defined. I know there was something mentioned in the example for these but I couldn't get much info from that. Please help me out here... Again, Thanks a lot. "Ron de Bruin" wrote: Maybe you can use a macro ? http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Sundar" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating Master sheet from child sheets
Hi Sundar
From the webpage Important: The macro examples use the LastRow or LastCol function that you can find in the last section of this page. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Sundar" wrote in message ... Thanks a lot for your help. I saw your example and I feel that my task is almost done. But there is one minor issue I am facing. When I copy pasted the code into my VB editor and ran it I got an compilation error for the LAST ROW and LAST column. Its saying that the Function not defined. I know there was something mentioned in the example for these but I couldn't get much info from that. Please help me out here... Again, Thanks a lot. "Ron de Bruin" wrote: Maybe you can use a macro ? http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Sundar" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |