Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Automatically filtering a list

  1. #1
    New Member DaveSwanton77's Avatar
    Join Date
    Apr 2002
    Location
    Bolton, Lancs
    Posts
    39
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a list of offices and the managers that are responsible for them. From the master list I would like to be able to automatically divide this list into individual lists on other worksheets in the same workbook.

    Column A Column B
    Office Manager
    Office 1 Mr Jones
    Office 2 Mr Jones
    Office 3 Mr Jones - sheet2
    Office 4 Mr Smith
    Office 5 Mr Smith
    Office 6 Mr Smith - sheet3
    Office 7 Mr Morris
    Office 8 Mr Morris
    Office 9 Mr Morris
    Office 10 Mr Morris - sheet4

    Any help would be appreciated
    Thanks in advance


    [ This Message was edited by: DaveSwanton77 on 2002-05-02 10:38 ]

    [ This Message was edited by: DaveSwanton77 on 2002-05-02 10:39 ]

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Cape Town,South Africa
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Why dont you just autofilter the list by manager so you only see their details ?Or did you have something else in mind buddy?

  3. #3
    New Member DaveSwanton77's Avatar
    Join Date
    Apr 2002
    Location
    Bolton, Lancs
    Posts
    39
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Its a bit more complex than that the list is populated with sales figures first and then the main list is split down to produce separate reports. This needs to be done without intervention by the user.


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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