Results 1 to 2 of 2

Thread: Need to create an excel template with many dependencies between columns and some prog

  1. #1

    Question Need to create an excel template with many dependencies between columns and some prog



    Register for a FREE account, and/
    or Log in to avoid these ads!

    This is my first time on this forum.. and I barely know about programming in excel.. I have an interesting template to be formed.. I need to input data into excel with lots of dependency..
    Cell in first column contains 6 fixed values from which you have to choose.. lets say those are A,B,C, (A&B), (A &C), (B & C), (A,B & C)
    Cell in second column depends on this and has customized options for each selected option in column 1. Lets say its this way..
    CELL 1 content-> A B C A&B A &C B & C A,B & C
    CELL 2
    Options ->
    1 1 1 A-1 & B-1 A-1 & B-1 A-3 & B-2 A-2 & B-2
    3 2 2 A-1 & B-3 A-2 & B-3 A-3 & B-1
    1&3 3 3 .. . .. .
    1 & 2 1 & 2 . . . .
    1 & 3 1 & 3 . . . ..
    2 & 3 2 & 3 . ..
    1, 2 & 3 1, 2 & 3 . ..

    Cell in column 3 depends on these choices filled in column 2 and has customized options
    If A-1 & B-3 : Then.. options available (A-1-1 till A-1-5) & (B-3-1 till B-3-6)
    And I want input box (vb script) kind of to enter the values.. suppose in case I want take input for 2 categories in the same cell like A-1 & B-1, I need to have both drop down options inputs in same input box.

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Complicated! You can achieve this with dynamic dependent dropdowns. See the attached file I've worked up, and also check out these links for different approaches:
    Karin.xlsb
    http://www.contextures.com/xlDataVal02.html
    http://excelsemipro.com/2011/05/a-dy...list-in-excel/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •