+ Reply to Thread
Results 1 to 5 of 5

Create the List of Employee

  1. #1
    Registered User
    Join Date
    06-28-2012
    Location
    India
    MS-Off Ver
    Excel 2013 and Excel 365
    Posts
    76

    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.
    Attached Files Attached Files

  2. #2
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    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
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    06-28-2012
    Location
    India
    MS-Off Ver
    Excel 2013 and Excel 365
    Posts
    76

    Re: Create the List of Employee

    Awesome, thank you very much

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    23,143

    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
    Attached Files Attached Files

  5. #5
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: Create the List of Employee

    Hi,
    One more ,this is a vba based solution.
    Attached Files Attached Files
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. create employee attendance annual summary sheet
    By Giri.hb in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 10-31-2014, 09:24 AM
  2. Create formula's for an employee schedule
    By BAWILS in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-27-2013, 11:12 AM
  3. Dynamically create workbook for employee tracking
    By DevilDog78 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-28-2012, 05:38 AM
  4. How do I create an Employee weekly scheduler
    By jv in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-31-2005, 10:36 AM
  5. [SOLVED] How do I create a monthly/fortnightly employee roster/timesheet?
    By Green Fingers in forum Excel General
    Replies: 0
    Last Post: 02-20-2005, 01:06 AM

Bookmarks

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