Segregate the data into different files

August 26, 2011 at 23:35:52
Specs: Windows XP

I have huge excel file with around 7 lacs entries. The data consists of the branch details. I want to segregate each branch details into different sheets. And the branch data is being repeated in the sheet. For e.g: hyderabad branch consists of 15-20 entries, Secunderabad branch has 20-30 entries. Now i want to seperate hyderabad branch details with all 20 rows in one file and secunderabad branch details with all 30 rows in another file. The process has to be repeated for all branch names. Can i have Macro for the same? Please help me to solve this problem.

See More: Segregate the data into different files

Report •

August 27, 2011 at 06:45:44
re: "I have huge excel file with around 7 lacs entries"

What's a "lac"?

Without knowing the layout of your spreadsheet, we can not offer a macro solution.

Please click on the Blue Line at the bottom of this response and post a subset of your data so that we can get a better understanding of what you are working with. Make sure that you remove/modify anything that could be considered confidential.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

August 29, 2011 at 01:03:21
Thanks Derby, I got the solutions.
By the way Lacs means Millions

Report •
Related Solutions

Ask Question