I have one worksheet with several thousand rows. I would like to create new workbooks based on filtering one column in that worksheet.

Based on the contents of one column, I would like to execute a macro that filters the data when the contents of that column changes and automatically create a new workbook each instance in which the contents of that column changes. I would like each filtered data set to appear in a new workbook. The new workbook could be saved and named the same as the contents of the cell that changes.

Thank you.