I have created a pivot table that keeps financial stats for different individuals. I would like to see if there's a way that I can send them all the same worksheet, but they would only be able to see and filter their information.
It would be possible but IMO that type of approach would be asking for trouble - especially if we're talking about otherwise confidential information.
You would be far better off creating individual files that contain their (and only their) information.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks