Results 1 to 4 of 4

Change a cell populated by a dropdown when the value of the source range changes

Threaded View

  1. #1
    Registered User
    Join Date
    08-29-2013
    Location
    NC, USA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Change a cell populated by a dropdown when the value of the source range changes

    I am trying to fill a series of cells from a dropdown box which refers to named range in a different worksheet within the same workbook. The values of the range are subject to change based on other variables and I want the end-use cells to vary as the range values change. In the attached demo sheet, On the worksheet "Labor" I want the values to change when the inflation escalators on the worksheet "Assumptions" change the labor rates in the named ranges on the worksheet "Assumptions."

    What actually happens is that when the range changes, then the selections in the dropdown change, but not the actual values in the fields, meaning my projections don't flow through the entire workbook properly.

    Any suggestions are welcome
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Show a dropdown when another field is populated
    By Lata in forum Excel General
    Replies: 11
    Last Post: 01-29-2013, 03:43 PM
  2. Y Axis data source changes based on the Named range listed in Dropdown
    By aravindhan_31 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-09-2012, 12:43 AM
  3. Dropdown list cell populated automatically
    By processchip in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-16-2011, 03:22 PM
  4. Returning Last Populated Cell in a range
    By RDMRDM in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2009, 07:17 PM
  5. Change populated cell names via macro
    By TJM in forum Excel General
    Replies: 2
    Last Post: 09-12-2006, 10:47 PM

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