Hello Everyone,
I am having a bit of difficulty figuring out if there is a way to accomplish what i am trying to do.
For example, I have an excel workbook which has a main "master" list that has all of the cars that are sold along with the name of the salesperson who sold it all the way to the right (Column 6)
What i am trying to accomplish:
I would like excel to automatically take all of the rows which have the same salesperson name in column six and sort them into separate sheets, but i would also like these individual sales person sheets to automatically update if information is changed, Deleted or added within the master list.
I have attached an Example of what i am working with and what id like to do.
Does anyone have any tips on how this can be accomplished?
Thanks you in advance for any help you can offer.
I am having a bit of difficulty figuring out if there is a way to accomplish what i am trying to do.
For example, I have an excel workbook which has a main "master" list that has all of the cars that are sold along with the name of the salesperson who sold it all the way to the right (Column 6)
What i am trying to accomplish:
I would like excel to automatically take all of the rows which have the same salesperson name in column six and sort them into separate sheets, but i would also like these individual sales person sheets to automatically update if information is changed, Deleted or added within the master list.
I have attached an Example of what i am working with and what id like to do.
Does anyone have any tips on how this can be accomplished?
Thanks you in advance for any help you can offer.