Forum Discussion
Separate lines on Sheets depending on condition
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
1 Reply
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,
