excel 2007
sheet 1 is data dump.
sheets 2 thru 6 are sheets by manager.
when i dump data of employee info in sheet 1, i need to copy and paste all rows that report to manager A sheet 2 (and the same for rest of manager sheets) automatically. My problem is that each employee may have mutiple rows. Each employee is identified by an ID.
i've tried several ways, but not able to succeed....
Bookmarks