title: Filtering data in excel
body: <p>I have a big database with sales for the branches of the supermarket network in Excel. I want to make a functionality that each branch sees only sales that belong to this branch. Each branch has a unique ID. </p>
  
  <p>What come to my mind is to assign to each branch a specific password in an additional sheet. Then, make the original data and the passwords hidden.</p>
  
  <p>Once a branch opens a file there is a sheet requesting id and password. Then there is a button that runs a macros for filtering the data. </p>
  
  <p>I know that this solution is pretty trivial. That's why, I was wondering, if there is any better (more protected) way to solve this? Any advice is appreciated. </p>