Why use a separate sheet?....just use Data Filter Autofilter to view only
the Staten Island or any other selected groups in your main
database.......then Data Filter Autofilter (it's a toggle) to return to
normal.....

Vaya con Dios,
Chuck, CABGx3




"Sr. Vice Deli" wrote:

I know using Acess would be easier, though I havent tackled it yet, I want to
be able to create a seperate sheet that has everyone of our employees who
work in say "Staten Island", So the main Database page is where the info is
stored, but kept there and moved to a seperate Staten Island Page... It
sounds like an Acess function but I was wondering if it can be done using
Excel... Thanks.