Automatically filtering a list

[DaveSwanton77]

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

 

[gareth]

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

 

[DaveSwanton77]

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.