macro to group data and define a range name

[joshnathan]

Hello,
I have a set of data that is 6 col by 6000 rows
Its all in alphabetical order by the first column.
almost all of the values in B repeat so there might be 5 rows with Alpha as the word in the B. All the information in cols 2-6 is different.
What i want is a macro that would group data with the same Bcol value into a range with the Bcol value as its name.
So for example:
It would find alpha in B the group the 6 rows of data (upto col 6) that contain Alpha as their B value into 1 range.

The reason i need this is so that on another sheet i can have a drop down for each name that would display the data in the range.

Regards,
Joshua


Making a mock file atm that should help explain.

[Leith Ross]

Hello joshnathan,

How would the names for the new ranges be determined?

[joshnathan]

the name of the range would be the word in cell A. This is the only word that repeats/ links several rows together.