Results 1 to 3 of 3

Thread: Help Needed Copying and Linking Information Between Sheets.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Help Needed Copying and Linking Information Between Sheets.

    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

Posting Permissions

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