Results 1 to 4 of 4

Automatically Show a default value in a drop down list

Threaded View

  1. #1
    Registered User
    Join Date
    09-19-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    48

    Thumbs up Automatically Show a default value in a drop down list

    Hi

    I have few columns of dependent lists and I want to show a value in the corresponding columns automatically by selecting a value from a drop down list in the first column.

    for Example - in the attached Sheet 4, Cell F2, I have a list of places and from Column G to J are all dependent to the previous column. Now If I select a Place in the cell F2 the corresponding cells should automatically return the first data from the respective drop down list. However, I should also be able to change them if required. Is this possible?

    Thanks for helping

    Pal
    Attached Files Attached Files
    Last edited by pal_slg; 10-09-2011 at 12:08 PM.

Thread Information

Users Browsing this Thread

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

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