Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Now I have four sheets, and one list “area”. The data of area is "North","East","West" and "South". I want to each sheet show each area data. For each area have different layout and calculation, I need to reduce the data to each sheet. And each sheet data can't show the other area data.
Is there any way to achieve it? Thanks a lot!
Can u share ur source file???
Use section access, give each user access for his area, and for the sheets you can show/hide the sheet depending on the logged in user.
Can we do section access to each sheet? If so, how?