Results 1 to 3 of 3

Thread: Help Needed Copying and Linking Information Between Sheets.

  1. #1

    Help Needed Copying and Linking Information Between Sheets.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Attached Files Attached Files

  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    The simplest and most efficient way would be to use PivotTaqble
    Hope that helps

    Roy

  3. #3
    PivotTable Example. You can build of modify this easily enough.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •