Replicating data from master sheet based on 2 criteria

[kate8301]

Thank you for reading my post, I could really use expert help on this!

I have a master spreadsheet created to track expenses (attached). Each line of the spreadsheet refers to an expense, and each expense is assigned a "Division" (ex. A, B, C, D, E) and Region (North America, Latin America, Europe, ME&A, or AsiaPac). I need to build functionality into the spreadsheet whereby various users can open the spreadsheet and have read-only access to just the expenses they have incurred for their Division and Region. In other words, I want Mr. Smith to be able to see only expenses for Division B North America and nothing more. This creates of combination of 25 divisions and regions, with 25 users who need to be able to access read-only data on their division and region.

Can someone give me an idea as to the best way to accomplish this? I have considered Pivot tables, IF statements to force an expense line item to a certain tab then password protecting each tab, etc.

I know there has to be a better way to do this, but I am at a loss for what to do and am running into a project deadline on this.

If you're able to propose a solution, can you please provide guidance on how I can accomplish what you suggest?

Your help is MUCH appreciated!