+ Reply to Thread
Results 1 to 5 of 5

Data Validation - How to update cells when a name is selected from a Data Validation List

  1. #1
    Registered User
    Join Date
    11-14-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    8

    Data Validation - How to update cells when a name is selected from a Data Validation List

    Hi,

    I was wondering whether it is possible to see different data depending on the name that is selected in the Data Validation list that I have.

    At the moment, I have People's names in the Data Validation list (Cell C4 in the sample sheet attached).

    On the same sheet, I have created a table for them to input data (i.e. no of calls taken, no. of complaints etc). If possible I'd like the sheet to show the relevant data for the relevant name chosen in the Data Validation list - i.e at the moment when I select a different name in the Data Validation list, the cells do not change depending on that name. The cells remain as they were previously.

    Sample sheet.xls

    E.g in the sample sheet attached, to see the problem please choose a different name in the data validation list, and you will still see the same numbers. Ideally I'd like the cells to contain different numbers depending on who is chosen from the list.


    Appreciate any help whatsoever,
    Thanks,
    Mo

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Data Validation - How to update cells when a name is selected from a Data Validation L

    See if this helps you. Dapanted data validation.

    http://www.contextures.com/xlDataVal02.html
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    11-14-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Data Validation - How to update cells when a name is selected from a Data Validation L

    Hi Fotis,

    I'm sorry I've tried looking at this but I can't seem to apply it to my problem, I think it might not be relevant - If I did it this way, I'd have to create data validation lists for all of the labels on the left hand side, with all the possible numbers that the values could take...

    Sample sheet.xls

    The users will be manually inserting the data into this sheet, I'd like the sheet setup so that whenever someone chooses a different name in the data validation list, the relevant data appears. As mentioned previously, currently when the name is being changed the cells remain as they were. I'd like the cells to correspond to the choice that is selected in the Data Validation list.

    Is this possible in Excel? (I thought anything was until I came across this problem... !)

  4. #4
    Registered User
    Join Date
    11-14-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Data Validation - How to update cells when a name is selected from a Data Validation L

    I wasn't able to understand how the link you sent applied to my issue, as I'm still a beginner in Excel and am a lousy user of it

  5. #5
    Forum Contributor
    Join Date
    10-19-2012
    Location
    chennai
    MS-Off Ver
    Excel 2013
    Posts
    134

    Re: Data Validation - How to update cells when a name is selected from a Data Validation L

    Hi Movali01,

    From where you get those values?

    if you provide the sheet then we try to figure it out.


    Regards,
    Rajan.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06049 seconds
  • Memory Usage 8,932KB
  • Queries Executed 15 (?)
More Information
Template Usage (31):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (5)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (5)postbit_legacy
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (4)showthread_bookmarksite
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (46):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1