+ Reply to Thread
Results 1 to 4 of 4

Update list

  1. #1
    Forum Contributor
    Join Date
    06-21-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    179

    Update list

    Gurus,

    I have a list (b6) that has values that are changed (D11:D13) based on the value of another list (B3). It works but I am hoping that when (B3) is changed, the value in (B6) updates at the same time to the first one in the list.

    Example
    B3 = USA
    B6 = a

    When I change
    B3 = China

    B6 remains "a" until I click on it and choose either FOB, Air or Sea.

    I would like to see that when I change B3 to China, the Value in B6 changes to FOB automatically

    TIA,
    Tim

    Book3.xlsx

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Update list

    I have created two named ranges USA and China and notice the data validation for B3. Also a conditional formatting is used to hide the content of B6 if B3 is changed and the value does not belong to B3.

    For detail see the attached.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Contributor
    Join Date
    06-21-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    179

    Re: Update list

    Sktneer,

    Thanks this works great!!!

    Tim

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Update list

    You're welcome and thanks for the feedback also.

+ 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. Would like to update stock list from daily sales list
    By DIPPYDOR in forum Excel General
    Replies: 6
    Last Post: 05-29-2014, 10:53 AM
  2. [SOLVED] Using Data Validation List to update customer address list
    By Rosco88 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-29-2014, 10:27 AM
  3. Update the original list with filtered list updation
    By jd_dahe in forum Excel General
    Replies: 0
    Last Post: 09-03-2012, 09:01 AM
  4. Replies: 7
    Last Post: 12-15-2010, 07:39 PM
  5. Update a Combo Box List, which list is on a different Worksheet
    By chamdan in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 11-06-2008, 10:15 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