Hide some rows from other users.

[JosipTopic]

Hello, I'm relatively new in Excel, and i need to do for my boss one excel, that shows company's weekly goals.
His group of companies counts 4 companies and practically he asked me to hide parts of workbook or
only parts of sheet/rows to be visible to only a user that works in that company.

so it would be like this
on one sheet it would be goals for all 4 companies, and user from company A would see part in a sheet that refers to company A.
My boss want's him to see everything, and workers to see their company's part in sheet.


THank you.

 

[fadee2]

hi,
It would be easier for people trying to help if you can use XL2BB to post a copy of your data that they can paste in to a spreadsheet : XL2BB - Excel Range to BBCode