distribute data in single sheet to multiple sheets

I have data in a worksheet that I need to breakdown further into multiple sheets.

The worksheet is formatted as follows: It contains data in columns A-L. I want to breakdown the data further into sheets according to the data that is found in column G. As an example, say I have 1,000 rows of data and in column G there are a number of different branch numbers in each row. So there may be 250 rows with branch 450, another 250 rows with branch 360, another 200 rows with branch 777, and finally 200 rows with branch 888. In this case I want to create 4 new sheets (450, 360, 777, and 888) and copy only the data in the main sheet that corresponds to same branch.

Actions would be as follows:
copy 250 rows to tab "450"
copy 250 rows to tab "360"
copy 200 rows to tab "777"
copy 300 rows to tab "888"

Any comments are much appreciate. I have attached a data sample along with desired output, if needed. One note: the data comes in each day as one single sheet of data and the number of branches varies day-to-day, as such, code would need to create new sheets for each branch found.

This macro I have for this kind of work requires that the sheets be named EXACTLY by the values you will be matching to. So in your sample sheet, I had to rename the sheets to 450, 360, 777 and 888.

Once that is done, this should work fine.

Please Login or Register  to view this content.

Try this:

Please Login or Register  to view this content.

This will always verify the sheet exists, create it and format it if needed, then parse out the data.

Please Login or Register  to view this content.