Results 1 to 12 of 12

Multi cell for drop down list more than one column

Threaded View

  1. #1
    Registered User
    Join Date
    11-26-2012
    Location
    Cannock England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Multi cell for drop down list more than one column

    Hi All

    Hope someone can help, I am creating an excel questionnaire with drop down answers, these are graded 1-10 with the next cell being the discriptive text, needs to be as sheet 2. I am trying to create a drop down list for Cells A1 and B1 together from a list (table) on sheet 2 but can only get it to show 1 column at a time. Attached a spreadsheet showing what i am trying to do, sheet1 cell B1 press dropdown arrow and it dispays both column from list on sheet 2, on selecting it populates cells A1 and B1 on sheet 1. I am keeping the grade seperate to the comments as the comments will change and there will be 20 questions with varied responses for each grade, eg next question may be how often do you....... and the drop down list would be 1 never - 10 always etc. Also I need to both the number and comments in the droplist view when selecting. I know excel can do this but got completely lost on combolist, surely if 2 cells are selected excel can pick from a droplist with 2 cells in the list.

    Regards

    Graham
    Attached Files Attached Files

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1