I'm looking for a Macro that will take a column of names and create an excel file for each name. The row data plus a header should carryover.

The excel file name should be derived from the name in Column B. Note that many rows will have duplicate names since each client name may have different data points, but they need to receive a single backup file per name.