Separate lines on Sheets depending on condition

[Mohammed Almaghi]

greetings everyone 

i'm newbie here

i need to separate rows on Sheets depending on condition let me explain

i have 3 columns 

1-UserName

2- CustomerName 

3-Cost

i need to separate rows on Sheets depending on column User name
So that each user on a separate page fetch their customer data on his pages and page name will be UserName

[#2]

@Mohammed Almaghi If you create a PivotTable with UserName in the Filter field, you can use the Show Report Filter Pages method, which will create a new PivotTable worksheet for each name in the list.

HTH,