I currently have a master excel sheet that has the names of about 20 different sales people, and a new row is created, with the salesmen name in column A, whenever they make a sale. But, I now want this data to be available to the salesmen, but I want only them to only be able to view their info, not everyones. So, I am going to create 20 different individual files, one for each salesman.
Is there a formula that I can use for these 20 different spreadsheets to update for that specific salesmen every time I update the master sheet?
Aucun commentaire:
Enregistrer un commentaire