tsunami1977
Board Regular
- Joined
- Jan 24, 2005
- Messages
- 64
Hello!
I have a master file where we track activities of the entire US region. In this file, we have the US data which then feeds into 40 worksheets (one sheet for each individual sales rep). Each week I need to distribute the 40 worksheets to each individual but only his/her own data.
Right now I save the master file as 40 individual files and then delete all the other worksheets before sending it out.
Other than saving the file 40 times, is there an easier way to do this?
Any suggestion would be helpful.
Thank you!
I have a master file where we track activities of the entire US region. In this file, we have the US data which then feeds into 40 worksheets (one sheet for each individual sales rep). Each week I need to distribute the 40 worksheets to each individual but only his/her own data.
Right now I save the master file as 40 individual files and then delete all the other worksheets before sending it out.
Other than saving the file 40 times, is there an easier way to do this?
Any suggestion would be helpful.
Thank you!