split excel into multiple sheet

[yogi]

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..

 

[Ron de Bruin]

Hi yogi

Start here
http://www.rondebruin.nl/copy5.htm

 

[yogi]

Hi yogi

Start herehttp://www.rondebruin.nl/copy5.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm






- 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.

 

[yogi]

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

 

[Ron de Bruin]

You are welcome