Need Help With Copying & Linking rows

[RB737]

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 worksheet 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 rows to automatically update if information is changed in them or if they are deleted on either the salespersons sheet or the master sheet.

Does anyone have any tips on how this can be accomplished?

Thanks you in advance for any help you can offer.

 

[vds1]

Start Here

VLOOKUP - Excel - Office.com

 

[RB737]

Thank you for the Tip above, i am currently trying it out.

I am having a little trouble manipulating the VLOOKUP Function to Look for a cell value and copy/link the entire row to a new sheet.

Also, i am looking to find a solution that will require me to enter the needed Function/Code a minimal amount of times and automatically copy and link specific rows based on a cell value to a new sheet.