I have a spreadsheet of quotes, samples, and orders. Each row includes
a "representative" field. I want to sort by "representative", then
move that representatives data to a new workbook so I can send to them
for follow up. There are about 40 columns and EVERY column (including
formating) needs to go to the new workbook. Basically I'm just
separating the workbook into separate workbooks so each rep sees only
the information for their territory.

I looked at the pivot table and didn't see how that can help me.

Right now I'm sorting, then cutting and pasting the rep's individual
rows to the new spreadsheet/workbook. Then saving it with their name.

There's got to be a better way and I sure would appreciate anyone's
help.

Thank You,
Tahrah