I want to create the list of employee in another workbook (as in sheet "Store") from existing sheet "List of Employee". Is it possible if i change the cell "b2" in store sheet HO to MZRC or any other as in dept column in sheet "List of Employee", total list of employee under this dept start appearing in the store sheet. if resolved this will be great help.
Bookmarks