+ Reply to Thread
Results 1 to 5 of 5

Employee Database

  1. #1
    Registered User
    Join Date
    08-23-2017
    Location
    Tuzla
    MS-Off Ver
    2016
    Posts
    10

    Question Employee Database

    Hi all,

    I was wondering if there is a way to combine an employees name with his code.
    This is what I got:
    One Excel Worksheet, Sheet1 has the names and their code (A1, B1).
    Sheet2 is a form where employees obligate tools.

    My idea is when I type their code in the form that it automatically fills their name.

    Attached is an example file.
    Attached Files Attached Files
    Last edited by longchamp; 09-27-2019 at 06:55 AM.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,499

    Re: Employee Database

    .
    Look at VLOOKUP

  3. #3
    Registered User
    Join Date
    08-23-2017
    Location
    Tuzla
    MS-Off Ver
    2016
    Posts
    10

    Re: Employee Database

    Great, thanks for the quick reply!

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,499

    Re: Employee Database

    .
    You are welcome.

  5. #5
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    3,885

    Re: Employee Database

    Hi there,

    See if the attached version of your workbook does what you need.

    It uses the following formula in Cell B2:

    Please Login or Register  to view this content.
    It also uses data validation in Column A so that you can select the Employee Id's from a dropdown list.


    Hope this helps - please let me know how you get on.

    Regards,

    Greg M
    Attached Files Attached Files

+ 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. Employee Vacation Tracking Database
    By helponmacro in forum Access Tables & Databases
    Replies: 4
    Last Post: 06-28-2017, 11:46 PM
  2. macro programe for employee database
    By sambhaji.gaikwad in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2015, 02:35 AM
  3. Employee Training Log Database
    By BeckyK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2011, 01:56 PM
  4. Employee Database in access
    By Access Employee Database in forum Excel General
    Replies: 7
    Last Post: 07-23-2009, 07:50 PM
  5. Help with employee database
    By Timeclock in forum Excel General
    Replies: 3
    Last Post: 06-20-2009, 11:25 PM
  6. Employee expense database
    By phproxy in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2009, 06:32 PM
  7. Dependant Value Return - Employee Database
    By yahnivek in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-08-2009, 11:41 AM

Tags for this Thread

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