You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
We have a situation where one of our teams uploads an excel doc that has a column for who the manager for each team is assigned and I would like to be able to filter out each of those managers assigned teams into a separate page/whether it be by excerpt or anything really and then use the secure add on to lock that excerpt or box down with password access for just that manager. All of the data will be coming from one table…
I am trying to use table filters and charts, but when I try to put the table filter macro into the excerpt macro, and it doesn’t like that. I am open to all suggestions. We haven’t purchased any add ons yet…wanting to see if I can find a solid option.
ideally I would like the excel doc to automatically import to a table so if a new one gets uploaded, it will automatically do the filters I create..