Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Germany, Germany
    Posts
    169
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cascading Lists over varios sheets (XP SP3 / Gener

    Hello everybody,

    I am trying to find a way to define a cascading list over various sheets. In the attached file, you will find the sheet "Test". In there are two columns. In the first you may choose, which version you want to get the data for the second column from. The values for both columns can only be chosen from a list (Data | validity... ; I hope this is translated correctly, in German it is Daten | G

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cascading Lists over varios sheets (XP SP3 / Gener

    You can use the INDIRECT function.
    Select cell Test!C4.
    Redefine the name rngAssortment as
    <code>
    =OFFSET(INDIRECT(Test!B4&"!$B$2"),1,0,COUNTA(INDIR ECT(Test!B4&"!$B$3:$B$500")),1)
    </code>
    Since B4 is a relative reference, and since C4 is the active cell, the name will always refer to the cell to the left of the active cell.

    (PS I had no problem at all understanding what you meant, but the official English term is Validation) <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Germany, Germany
    Posts
    169
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cascading Lists over varios sheets (XP SP3 / G

    Hello Hans,

    is there anything about Excel you do not know? Thank you very much for your answer, which as ever fits 100%.
    Also thank you for giving me the correct term.

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cascading Lists over varios sheets (XP SP3 / G

    >>> Is there anything about Excel you do not know? - <img src=/S/yep.gif border=0 alt=yep width=15 height=15>

    He does not know where to find cell: IV65537 - <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>
    Regards,
    Rudi

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cascading Lists over varios sheets (XP SP3 / G

    But I do: in Excel 2007!

  6. #6
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cascading Lists over varios sheets (XP SP3 / G

    <img src=/S/razz.gif border=0 alt=razz width=25 height=17> <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Regards,
    Rudi

Posting Permissions

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