Break a excel file into various excel sheet based on a column

[ROHAN999]

Sir

i am attachinh here with a sample of my excel file,inwhich ,i want that my this sample file can be breaked into various excel files based on coulmn b of my sample dummy sheet.

Row 1 in my file is a header: Which should come in every excel file as first row as header after they breaks in parts.

Then items in column b are like:5,6,25,12,16 and like wise. So seprate files with the name 6,25,12,16 and like wise need to be created seprately and intems belongs to 6,25 and likewise sholud come in the corresponding excel files.

Thank you

[patel45]

show please one desired result

[jindon]

Try

Please Login or Register  to view this content.

[ROHAN999]

Your code amazingly works,thanks alot for it

but i need a code so that despite of sheets in the same workbook it may give me separate excel files for each entity in column b

your code make sheets ...despite of sheets a want seprate excel files for it..

For ex - i have made a foder named as "spread excel" in c drive in it my excel file is with the name "file"

now kindly modify your code to suit my need so that "file" can be breaked in the same folder "spread excel" as desired

[jindon]

Try

Please Login or Register  to view this content.