I have sales representatives data in a workbook in a "Summary" tab. Each rep has a row of data. I want each rep to have its own sheet. Each sheet will only show data for each specific person and name the sheet as the person. Number of reps varies. At the end i want to have "Summary" tab with all data, and "Rep1", "Rep2", etc. with only their own data.
Thanks
Thanks