Creating a new formula
and i meant "sheet", sorry
"CLR" wrote:
I would recommend you add both of your lists together on one sheet, and
install one additional column titled DEPARTMENT.........then you can easily
separate the active/inactive/by Department by using the Data Filter
AutoFilter feature......
Vaya con Dios,
Chuck, CABGx3
"vanchi233" wrote:
I have a worksheet for active employees in one department and another sheet
for active employees in another department. Now these will remain in their
distinctive active sheet until their active status is change from Y to N.
I have created a third sheet where I would like excel to immediately
recognize the change from y to n on any of the active sheets and populate the
same info on the new row except with a changed "N" for inactive status.
Is this possible?
|