Hello. I am trying to automate-send some reports for different people.
I found a code that sends workbooks the way I want (Thanks to this site), but the thing is I want to send each person their own scorecard (meaning that the filter will have to change with every email based on a cell value). The cell is connected to a table with the employee's name (the same as in the filter) and their emails. Each email has to have a protected sheet where they cannot change the filter. (The other sheets will only display their performance without the slicer being there to be used)
I hope I was able to explain well. I would appreciate any help.
Thank you very much.
I found a code that sends workbooks the way I want (Thanks to this site), but the thing is I want to send each person their own scorecard (meaning that the filter will have to change with every email based on a cell value). The cell is connected to a table with the employee's name (the same as in the filter) and their emails. Each email has to have a protected sheet where they cannot change the filter. (The other sheets will only display their performance without the slicer being there to be used)
I hope I was able to explain well. I would appreciate any help.
Thank you very much.