+ Reply to Thread
Results 1 to 3 of 3

Assign data to option of dropdown list

  1. #1
    Registered User
    Join Date
    04-21-2020
    Location
    Netherlands
    MS-Off Ver
    Office 2016
    Posts
    2

    Assign data to option of dropdown list

    Hey everyone,

    I want to assign data to an option out of a dropdown list. The data consists out of several columns and rows. If I chose a different option out of the dropdown list, I want to be able to fill in different values without changing the data from the previous option. Is this possible. Can anyone help me? Thanks!!
    Attached Files Attached Files
    Last edited by joosttrommelen; 04-21-2020 at 10:02 AM. Reason: adding data

  2. #2
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Office 365
    Posts
    366

    Re: Assign data to option of dropdown list

    Hi joosttrommelen,

    I would recommend, If you can load some sample data; it would be easy to understand your expectation!

    Thanks,
    Rajeshkumar R

  3. #3
    Registered User
    Join Date
    04-21-2020
    Location
    Netherlands
    MS-Off Ver
    Office 2016
    Posts
    2

    Re: Assign data to option of dropdown list

    Dear Rajeshkumar R,

    I added an example!

+ 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. Dropdown box suggested list option by typing the first letter of an option
    By jennis7242 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-19-2017, 10:39 PM
  2. [SOLVED] Macro Help Needed to produce a new tab for each option in a dropdown List
    By karimel_romeo in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-03-2017, 04:31 PM
  3. [SOLVED] If an option in dropdown list selected return value 0
    By hanif in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2016, 10:16 AM
  4. using a dropdown list instead of option buttons
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2015, 10:16 PM
  5. Replies: 1
    Last Post: 05-19-2015, 12:42 AM
  6. [SOLVED] How to assign a value to each name in a dropdown list?
    By Nicholas_jay in forum Excel General
    Replies: 4
    Last Post: 03-26-2014, 07:43 PM
  7. Display Cell Data from a cell after selecting option from dropdown list.
    By RoyalleSky in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-20-2014, 06:04 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