DaveSwanton77
New Member
- Joined
- Apr 15, 2002
- Messages
- 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
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