Help Needed Copying and Linking Information Between Sheets.

RB737

New member
Joined
Apr 16, 2013
Messages
1
Reaction score
0
Points
0
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.
 

Attachments

  • Example.xlsx
    11.5 KB · Views: 12

dond427

New member
Joined
Jan 7, 2013
Messages
13
Reaction score
0
Points
0
PivotTable Example. You can build of modify this easily enough.
 

Attachments

  • Example.xlsx
    48.3 KB · Views: 9
Top