Download the featured file and/or copy the code here https://www.bluepecantraining.com/excel-vba-create-new-worksheet-for-each-unique-item-in-list-copy-record/

This video tutorial features VBA code that creates a new worksheet for each unique item that it finds in a list and then copies that record to the new sheet.

In the featured scenario we have a thousand transaction records. The VBA code creates a new worksheet for each branch location that it finds in column D and then copies the record to that sheet. We end up with a sheet for each branch containing all the records for that branch.
------------------------