VBA to split report according to segmentation of rows unique values to sheet check

Wow it works sir I do have small change where split columns AA change to AC how to change code if it run on AC column

@ every segment i need two rows down above header i need to update this "FY-16 Business Entity Report for the &" Dispute