Perhaps this previous post might give you
some possibilities to explore further: http://tinyurl.com/5ejr2
(the key column in your case would be the officers' names)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Kenny Dee" wrote in message
...
I have several sheets already setup and ready to accept info entered from
one
main sheet. Here's the problem I have. I assign cases to officers in my
building. I have created sheets for each of the officers. So that the
clients will go into the correct location. I enter the info on main sheet
where most of this information is going to be entered such as last name,
first name, case number, and so on. How do I get the information for each
of
them to drop into the correct sheet that I want it to go to.