+ Reply to Thread
Results 1 to 5 of 5

Excel dropdown lists

  1. #1
    Registered User
    Join Date
    07-09-2015
    Location
    USA
    MS-Off Ver
    Excel & Access 2013
    Posts
    3

    Excel dropdown lists

    Hi all,

    I have created this dropdown list in excel that has 8 names in it. I want it to look up some data but i also want each name to eb updatable manually, Is this possible in excel with VBA? Im stuck!
    Departments.xlsx

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,879

    Re: Excel dropdown lists

    What do you exactly mean by "but i also want each name to eb updatable manually"

    Could you clarify?
    Cheers!
    Deep Dave

  3. #3
    Registered User
    Join Date
    07-09-2015
    Location
    USA
    MS-Off Ver
    Excel & Access 2013
    Posts
    3

    Re: Excel dropdown lists

    Like when I select a name from the drop down list..I want to be able to put data in the table manually for that specific selection and also have some pulled with fomulas into the selection. take a look at the attachement i included

  4. #4
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,879

    Re: Excel dropdown lists

    I guess you will need to tell me where the Drop Down List is. When I open the file, the file is having issues and is repaired, and as a result, the Data Validation is being removed..

    Else, attach a new file with a working DV & Expected Result.

  5. #5
    Registered User
    Join Date
    07-09-2015
    Location
    USA
    MS-Off Ver
    Excel & Access 2013
    Posts
    3

    Re: Excel dropdown lists

    I dont know if I can re attache the file. There is no data yet but I want to have each of the departments enter their own data after selecting their department name from DV list. Or may be I'll have to create another page or form for data entry? The data is basically just the times

+ 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. Linking two dropdown lists in excel
    By Paragoomba in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-03-2013, 11:00 AM
  2. Excel dropdown lists
    By NicciB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2008, 03:35 PM
  3. [SOLVED] Excel 2002 dropdown lists
    By projectmgr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-14-2006, 07:40 PM
  4. IF/THAN with regards to 2 Dropdown Lists in Excel?
    By TATERTOT1980 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2006, 06:38 PM
  5. [SOLVED] Excel Spreadsheet - Formatting Dropdown lists
    By Formatting of drop down lists in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-20-2005, 05:05 PM

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