one way is to have a column to indicate
DEPTdatafilterautofilterfilterbydeptcopy visible cells OR use a macro
to do it that way or a for/each loop

--
Don Guillett
SalesAid Software

"Pat" wrote in message
...
I am working in two worksheets. One shee is "All" and the second sheet in
broken down by departments; however, when I get information from the
departments, I want to mark off the informaton in the "All" sheet and have
that information automatically copied int he department sheet. Is this
possible?