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

Anju - Dec 22, 2015 at 10:03 AM

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.