Jul 13 2022 04:10 PM
I have a large spreadsheet that has a column with people names. This file is stored in SharePoint. The idea would be I share the link to each person who appears in the name column and they filter for their name only for them to view what's applicable to them.
Seems simple enough but for some reason people at my company cant seem to figure out simple things like they need to filter on their name, even if I tell them. Ridiculous but that's the say it is.
Is there a way to generate a link for each person to the same excel file but the link will include filtering so they will be default only see rows that apply to them?
If this isn't possible I could create individual files for each person with tis own link and then bring all these together into a single Master file which i can see but that's a bit laborious because there could be hundreds of people to create individual files for. Or is there an easy way to do this?
Suggestions welcomed.
Thanks.
Jul 15 2022 06:45 PM
Jul 19 2022 05:19 PM
@ecovonrein Thanks for the suggestion. Unfortunately the format of the username the code will return won't match the format of the name column that I want to apply the filter automatically.
Jul 20 2022 02:39 AM