Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
split excel into multiple sheet
Dear all,
I have an excel with huge data, i want to split data of workbooke into multiple sheet in same excel. I want to split by using column head. in my case it is R.O., I want to split by R.O. wise. and new sheet should be name automaticaly by R.O. name. I will be very thankfull if any one give me solution for this.. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
split excel into multiple sheet
Hi yogi
Start here http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "yogi" wrote in message ... Dear all, I have an excel with huge data, i want to split data of workbooke into multiple sheet in same excel. I want to split by using column head. in my case it is R.O., I want to split by R.O. wise. and new sheet should be name automaticaly by R.O. name. I will be very thankfull if any one give me solution for this.. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
split excel into multiple sheet
On Feb 18, 9:27*pm, "Ron de Bruin" wrote:
Hi yogi Start herehttp://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm "yogi" wrote in ... Dear all, I have an excel with huge data, i want to split data of workbooke into multiple sheet in same excel. I want to split by using column head. in my case it is R.O., I want to split by R.O. wise. and new sheet should be name automaticaly by R.O. name. I will be very thankfull if any one give me solution for this..- Hide quoted text - - Show quoted text - Ron de Bruin thanks i tried u r example but my data is huge it is contain 3000 ROW and 32 column, i dont have knowledge of visual basic so i cannot edit vb program, i will be very thankfull if u give us code , i will insert code in my excel. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
split excel into multiple sheet
On Feb 19, 12:16*pm, yogi wrote:
On Feb 18, 9:27*pm, "Ron de Bruin" wrote: Hi yogi Start herehttp://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm "yogi" wrote in ... Dear all, I have an excel with huge data, i want to split data of workbooke into multiple sheet in same excel. I want to split by using column head. in my case it is R.O., I want to split by R.O. wise. and new sheet should be name automaticaly by R.O. name. I will be very thankfull if any one give me solution for this..- Hide quoted text - - Show quoted text - Ron de Bruin thanks i tried u r example but my data is huge it is contain 3000 ROW and 32 column, i dont have knowledge of visual basic so i cannot edit vb program, i will be very thankfull if u give us code , i will insert code in my excel.- Hide quoted text - - Show quoted text - Dear Ron de Bruin thank you very much. your example help me a lot, it will same my 2 hours. now with your example i can do my work within 10 minutes. thanks once again |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
split excel into multiple sheet
You are welcome
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "yogi" wrote in message ... On Feb 19, 12:16 pm, yogi wrote: On Feb 18, 9:27 pm, "Ron de Bruin" wrote: Hi yogi Start herehttp://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm "yogi" wrote in ... Dear all, I have an excel with huge data, i want to split data of workbooke into multiple sheet in same excel. I want to split by using column head. in my case it is R.O., I want to split by R.O. wise. and new sheet should be name automaticaly by R.O. name. I will be very thankfull if any one give me solution for this..- Hide quoted text - - Show quoted text - Ron de Bruin thanks i tried u r example but my data is huge it is contain 3000 ROW and 32 column, i dont have knowledge of visual basic so i cannot edit vb program, i will be very thankfull if u give us code , i will insert code in my excel.- Hide quoted text - - Show quoted text - Dear Ron de Bruin thank you very much. your example help me a lot, it will same my 2 hours. now with your example i can do my work within 10 minutes. thanks once again |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split a sheet in Excel | Excel Worksheet Functions | |||
split sheet into tabs in EXCEL | Excel Discussion (Misc queries) | |||
Split text file into Excel sheet and separate the final results intoa new sheet | Excel Worksheet Functions | |||
How do I split form controls in a sheet in excel? | Excel Discussion (Misc queries) | |||
Split rows into multiple sheet if..... | Excel Programming |