I created a table in Excel 2010 with the name of several teams (in column B) and the names of the employees (in column C).
I would like to create named ranges of the employees where the name of the team is identical.
E.g.
Column B Column C
VVM John
VVM Roy
VVM Linda
TZ Jack
TZ Carol
etcetera.
The first named range's name should be Team_VVM (referring to John, Roy and Linda).
The second named range's name should be Team_TZ (referring to Jack and Carol).
If Teammembers are added, the named range names should dynamically change.

Thanks for the help.