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

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

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.

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

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