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.