VBA to move data to new worksheets based on cell value

[GregStewartPTC]

I am needing to create a vba/macro to move data from one worksheet to another based on the value of a cell in a specific column. Ideally the new tabs would be named with the value that is in the cell, to make it easier to sift through once finished. Is this possible?

I've uploaded an example worksheet. All data that is sent to me is always under the worksheet 'Supply Data'. I need to filter based on the Branch Name in Column A - create a tab with that branch name - move all info from all rows containing that branch name to the tab. If it can somehow go back and delete the data after it has been moved, or even delete the entire worksheet would be even better, if that is possible?

I also realize I could sort this into a pivot table very easily, but because the data from Column F-M has to have a very specific custom sort for the reps to know which order to work their list from, it isn't a good option.

Thanks in advance for any help you can provide.

[Mumps1]

Try on a copy of your file:

Please Login or Register  to view this content.

[GregStewartPTC]

Thank you very much for the fast reply Mumps. This is perfect! +Rep and I'm marking solved.

[Mumps1]

You are very welcome and thanks for the rep.