Split Rows For Unique Values In A Column To Different Workbooks

Hi

Iam trying to segregate data based on the cell value(which is a Text) in a Column, cell value is repeated many times in the column. Iam trying to copy the entire row and all rows with same value into a new workbook with the cell value as name of the new sheet.

I did search and got below code, but it is not working properly.As I am new to coding I am not able to understand what is incorrect.

Can someone please suggest me what change is to be made and also add comments.

The column in my case is column number 33 which is AG and values are added from AG2.

Thanks.

Please Login or Register  to view this content.