Hi-
I'm trying to create a commission dashboard for all of my company's sales reps. What is the best way to accomplish this so that when I make changes to one worksheet it affects all of them? I don't want to just duplicate the worksheet for each sales rep because when I need to make changes to one worksheet I would have to change them all.
I thought the best way to do this would duplicate the worksheet and then change the filter so each sales rep is shown but if there's a better way I'd love to hear it.
Thanks.
Elena
2 answers
Joe-
Appreciate the quick response! I was able to figure it out by removing the filter I had for sales reps, and adding sales rep to the columns.
Thanks!
Elena
