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