+ Reply to Thread
Results 1 to 3 of 3

Dynamically update cell content from data validation list

  1. #1
    Registered User
    Join Date
    05-26-2020
    Location
    London
    MS-Off Ver
    2004, Office 365
    Posts
    2

    Dynamically update cell content from data validation list

    Hi everyone,

    I have already had a look at existing threads on the subject from 2005 but cannot get my head around it.

    I want to be able to dynamically update a cell content from a data validation list, without having to re-select the instance on the drop down list.

    I would have on one sheet a list of cells that would form the basis of my data validation drop-down list and on another sheet the drop down menu. The problem is, if I modify one instance of the base list, the already populated cell on my other sheet would not update without me having to manually reselect it:

    List1 banana < if i change "banana" to "mango" in list1, I want the cell value to dynamically update to "mango"
    apple
    lemon
    banana

    I have experimented with the offset function but that doesn't seem to apply to drop down list.

    I have some VBA experience but veryyyy basic but can pick up quickly : )

    Please see workbook attached.

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003
    Posts
    175

    Re: Dynamically update cell content from data validation list

    try something like this...
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-26-2020
    Location
    London
    MS-Off Ver
    2004, Office 365
    Posts
    2

    Re: Dynamically update cell content from data validation list

    Hi there,

    Thanks a lot for your answer. I did not manage to make it work but found a workaround with separate workbooks and hyperlinks.

    Cheers.

+ 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. Vlookup to update the duplicate results in list(data validation list)
    By cheTAN kc in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-16-2017, 10:06 PM
  2. Replies: 3
    Last Post: 05-09-2016, 08:27 PM
  3. [SOLVED] Data Validation: How to clear/delete the content of the cell and not Data Validation List?
    By lukelucky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-07-2015, 09:42 AM
  4. Replies: 4
    Last Post: 07-03-2014, 02:37 AM
  5. Replies: 21
    Last Post: 03-14-2013, 07:33 AM
  6. Replies: 5
    Last Post: 08-13-2011, 11:27 AM
  7. Replies: 1
    Last Post: 07-28-2005, 02:06 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