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.
Then loop down the list starting in L1 with the following macro. Change the reference to Sheet1 as necessary
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?
Bookmarks