vba to split unique values in column P:P along with existing sheet of partner

Dear expert

I have rawdata workbook i want split unique values as new workbook from column P:P to desire location save with new name along with existing sheet of Partner!

find the attachment of zipfile

I want split as workbooks of TE001 FY 16.xlsb FY-16 sheet name along with Partner, and another workbook TE003 FY 16.xlsb sheet name along with Partner from column P:P.

assume that TE001 rows more than 65000,TE003 rows more than 85000.

Regards


vba to split unique values in column P:P along with existing sheet.