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


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.