| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
