Hello,
I have a Master File with a lot of information in it that gets updated by my sales reps on a weekly basis. What I would like to do is create copies of this file so that each sales rep has one sheet/tab at the bottom. (Basically the exact same sheet x # of times and then just filter each one to a different rep).
All of the data will be always entered into the Master File, but for me to review a specific sales rep I would like to be able to have a sheet just for them.
Is there a way to copy the format of a spreadsheet but have the entire sheet reference to the Master sheet. Or is this something pivot table situation?
I know of a few ways to make this work but I don't think they are the best ways to do it. Any suggestions?
Bookmarks