If change in Column A - Copy paste data in new worksheet

[Closed]
Report
-
Hello,

Request your help. I have department wise data in a worksheet. Department name is given in Column A. I need to create new excel file for each department. So if there is a change in department name in Column A, I am looking for a macro which will copy the rows and paste in a new excel file.