How to split worksheet into multiple worksheets based on column content

I'm trying to break up a worksheet into several worksheets based on the data in the "branch" column.
I've tried to use other codes posted here, but, I can't seem to nail down the debug process and accurately identify the cells/columns that I need.
I have a header row of 7 columns:
member_id nps comments additional_comments Call Me! Number Branch

the data in the "branch" column is the one I need to be the defining one for creating the new worksheets. How do I modify/create the module code?

Difficult to provide an answer on your code, if you have not provided it. Suggest you post your code and a sanitized copy of your spreadsheet. It is easier to provide a solution when we can actually see the problem.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Please Login or Register  to view this content.

Hi

Assuming the Branch column contains lots of duplicates then the first thing you need to do is extract a unique list of branches.
If you have Excel 2010 then you can use the 'RemoveDuplicates' option after you have copied the range. Alternatively you could use an Advanced Data Filter to create a unique list

e.g.

Please Login or Register  to view this content.

Then loop down the list starting in L1 with the following macro. Change the reference to Sheet1 as necessary

Please Login or Register  to view this content.

However before splitting data into several sheets I'd urge you to consider why you need to do this. I've lost count of the number of times people have started out with data that's spread across many sheets, (often sheets for different years, months or even days) and then found that summarising/analysing the whole lot of data is rendered very difficult.

If you have a database and you periodically need to report specific branch information then the smart way is to use a separate sheet which is populated with Branch details with a Data Advanced Filter at run time.

What is the overall aim here?

Let's try this one.

Please Login or Register  to view this content.

You are welcome and thanks for the feedback.

Pls, next time, be carefull with rules of the forum, because my intention IS NOT to be the bad quy here!!