Creating sheet for only assigned individual based on master sheet

Mario M.

Hello,

I have a sheet which contains a combined view of Account Name and their assigned Accountant. The sheet has multiple rows and each Accountant can show up multiple times assigned to different clients.

What is the best formula to use so that I can create individual data sheets for each Accountant that will only pull assigned Accounts to them? I would also like this to be interactive so that if an account is re-assigned it is removed from their specific view.

Thank you

Paul Newcome

I would suggest creating a report that is filtered by "Current User".