Formula

[Guest]

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?

 

[Don Guillett]

one way is to have a column to indicate
DEPT>data>filter>autofilter>filterbydept>copy visible cells OR use a macro
to do it that way or a for/each loop