Automatically filtering a list

DaveSwanton77 · May 2nd, 2002, 08:41 AM

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 · May 2nd, 2002, 08:57 AM

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 · May 2nd, 2002, 09:02 AM

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.

May 2nd, 2002, 08:57 AM	#2
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	Why dont you just autofilter the list by manager so you only see their details ?Or did you have something else in mind buddy? __________________ Regards Gareth Visit The Excel Maniacs :<>: Have a Chat! :<>: Free Stuff!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 08:41 AM	#1
DaveSwanton77 New Member Join Date: Apr 2002 Location: Bolton, Lancs Posts: 39	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 ]

May 2nd, 2002, 09:02 AM	#3
DaveSwanton77 New Member Join Date: Apr 2002 Location: Bolton, Lancs Posts: 39	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.