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
|