I am posting a question in relation to a Section Access sheet/ field reduction.
I am currently building a personal tab on my dashboard and am building charts.Tthey will only be able to see data on this Sheet that relates to them,
i.e a selection/ reduction of data in a field like Total Hours. I was hoping to force a selection in either of the fields I have such as StaffName or StaffIndex obtain this. However the catch is that this will have to be based off their NTName.
In the other sheets I am using Total Hours but as a total figure and you can't drill to an individual breakdown. Viewers on the access point will not be able to build or edit on the access point so this will prevent them form just throwing in a listbox of StaffIndex and finding individual hours as this would make the whole process redundant.
Is it possible for me to make this personal tab where what they can view is based on their windows NTName and not effect the rest of my sheets. So its somewhat like using section access for a reduction of data in a field but I want it to only apply on one Sheet