How to save each change in list in new workbook

[cheechpr]

Hello,

I am trying to create a macro that will copy all the rows related to one item in a column and save it in a new workbook. I would want the macro to sort by a column and save all rows after each change in in teh column.

[dxider]

I think this post needs a bit more of explanation.
Can you describe the process better?

[cheechpr]

I think this post needs a bit more of explanation.
Can you describe the process better?

I get a data dump with all items that need attention and who they were originally assigned to, the data has cloumns with relevant information( time it was assigned, where it needs to be done etc) I need to breakout the data for each person that it was assigned and create a new file to email them. There are close to thirty different people that I need to send so want to see if I could create a macro to break out the data and create the new files and create the email if possible. If this is not possible, I am thinking of createing saved files for each person and then have them pull the data from the master file based on their name.

[snb]

Please, post a sample file illustrating your question.

[cheechpr]

Each change in the ID column is how I would want to break out the data.