Excel

[danielmarzec]

Good morning, is it possible to make a workbook available in Excel for many people, but with a division into individual formats, e.g. at the bottom, we have a bar divided into several categories category A category B category C category A I would like to divide and I would like to make it available to person X category B I wanted to share with the person Y if there is a possibility for something like this

[#2]

It depends on exactly what you want and which version of Excel and where the file is located/shared.
For example the 'traditional' way might be to use VBA/macro to run on open to detect user or prompt for user and then perform show/hide actions.
But macros are now blocked on the new excel in sharepoint (you can use local excel and allow macros if you security setting are set accordingly), but you could add a button for them to press that runs a script to peform some showing/hiding.
Either way is not as easy as a quick formatting setting.
Alternatively, I could suggest WorksheetA, WorksheetB, WorksheetC for users A,B,C and each worksheet is formatted accordingly and the cell just reference the needed values in WorksheetMaster. Then on open the users might be prompted with a 'There are external links, shoud values be updated?' type of prompt but then it will be formatted and showing the correct information for each corresponding user.

[#3]

@m_tarler 

Dziękuję za wiadomość.

Mógłby prosić do treści:

"Alternatywnie mógłbym zasugerować Arkusz roboczyA, Arkusz roboczyB, Arkusz roboczyC dla użytkowników A,B,C, a każdy arkusz jest odpowiednio sformatowany, a komórka po prostu odwołuje się do potrzebnych wartości w WorksheetMaster. Następnie, po otwarciu, użytkownicy mogą zostać poproszeni o monit typu "Istnieją linki zewnętrzne, wartości powinny zostać zaktualizowane?", ale wtedy zostanie on sformatowany i pokaże poprawne informacje dla każdego odpowiedniego użytkownika."   

pokazać przykład nagrywając w video? Bo nie bardzo chyba rozumiem jak to zrobić:(

Z wyrazami szacunku

[#4]

@danielmarzec  so it is hard to give you multiple files that link as I suspect those links would break on your end.  So in the attached I have a MAIN DATA tab that you can pretend is the master file:

and then 2 other tabs: R1 and R2 that you could image are separate files.

Both R1 and R2 are subsets of the MasterData and show the group R1 the data they need in the format they want and R2 the data they want to see and how they want to see it:

R1: Transaction/Sales/Promo info

R2: Fuel info

[#5]

@m_tarler Thank You