- Creating new sheet and transferring data to new sheet
- Automatically transfer data from one sheet to another in excel - Guide
- Macro to create new sheet and copy data - Forum - Excel
- Excel transfer data from one sheet to another ✓ - Forum - Excel
- Macro to Create New Workbook and Copy Data at Each Change of X - Forum - Excel
- How to automatically transfer data between sheets in Excel - Guide
You can use a filter to separate your data by person. Using the Goto > Special > Visible cells only, you can then copy only the filtered persons records to copy into a new sheet.