+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Populating Fields based on drop down selection

  1. #1
    Registered User
    Join Date
    07-15-2011
    Location
    Niagara Falls, Canada
    MS-Off Ver
    Excel 2007
    Posts
    1

    Populating Fields based on drop down selection

    Hi everyone;

    I have an excel spreadsheet with several different tabs. One of the tabs is a summary tab, where we input information from all the other tabs, right now we have to rummage through all the tabs and locate the information and manually enter it.

    in the first column there is a stand set of information (employee names), in the first row on each tab.

    What i would like to be able to do is create a drop down list of employee names on the summary tab, and based on that selection, fill in certian cells, with information from the other tabs in that workbook.

    geez i hope that makes sense.

    I am a bit unsure if I am looking at a vb script for this or some messed up version of HLookup and Vlookup.

    I'm certianly not an excel expert, I can do some basic stuff, any help or guidance would be appreciated.

    Thanks

    Gary

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Populating Fields based on drop down selection

    Please see the attachment.

    I've used a sheet_change event to trigger the search of data from the other sheets when a new name is entered in column 1 on the first tab.
    Attached Files Attached Files
    Martin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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