split column values as new wb along with 2 existing sheet (dashboard&pivot)

[breadwinner]

Dear Experts

I have macro code which run for split the values from A:A column and save as new workbook along with existing sheet of dashboard sheet for all partner name individual, usual code run for this here i want do addition performs with the code already split with dashboard i want split with sheet dashboard and also pivot sheet

i tried by adding same code with end with statement but it doesnt work for me help me

Please Login or Register  to view this content.

find the two attachment one is rawfile and output first file Aegis Infoware Pvt. Ltd file is what i expect

thanks alot

[breadwinner]

any experts help on this?