Create the List of Employee

1. Create the List of Employee

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.

2. Re: Create the List of Employee

In Cell A4

=IF(ROWS(A\$1:A1)>COUNTIF('List of Employee'!\$C\$2:\$C\$34,\$B\$1),"",INDEX('List of Employee'!\$A\$2:\$A\$34,SMALL(INDEX(('List of Employee'!\$C\$2:\$C\$34=\$B\$1)*(ROW('List of Employee'!\$C\$2:\$C\$34)-ROW(\$B\$2)+1),),COUNTIF('List of Employee'!\$C\$2:\$C\$34,"<>"&\$B\$1)+ROWS(A\$1:A1))))

Copy down as far as required

In B4
=IF(\$A4="","",INDEX('List of Employee'!B:B,MATCH(\$A4,'List of Employee'!\$A:\$A,0)))

Copy down and across as far as required

3. Re: Create the List of Employee

Awesome, thank you very much

4. Re: Create the List of Employee

See attached file - I've put a drop-down in cell B1 (yellow) so you can easily select the dept.

Hope this helps.

Pete

5. Re: Create the List of Employee

Hi,
One more ,this is a vba based solution.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1