Hello All,
I am a new user in this group. I love Excel and I always take up challenging Excel tasks, but I am lost with this one.
I am working on a workbook which contains a Master sheet which will be very long. This sheet contains a lot of details of sales. From this sheet I would like to copy all the data of each salesperson to his personal sheet which will be set by user, exactly as in the attached sample workbook. The Master sheet will be updated daily and I would like to keep updating the individual sheets of each sales person on a daily basis as well. I know this can be done . I have tried with Vlookup but without success. I would appreciate it if someone can give me the code or any other assistance on how to do this.
Thanks to all
JJM.Delta
Bookmarks