Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    Netherlands
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Validation from Lists (Excel 2002)

    Help - I'm stuck!
    I am creating a spreadsheet for to record asset details - particularly PC's (Desktop and Laptop) I want the user to enter data for each asset by selecting from a list of two (Desktop/Laptop) in column L in the attachment, and then get a list of valid machines of that category in cell N. List 2 (validated from column H) is made up by comparing the value in L6 with the value in column E, and copying in the appropriate value from column F. Unfortunately this gives blank cells in the validation list displayed in N6. How can I get rid of the blanks in the drop down list displayed in N6? I then want to replicate this down columns L and N.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Validation from Lists (Excel 2002)

    Name the Desktop and Laptop list
    Desktop =Sheet1!$E$6:$E$11
    Laptop =Sheet1!$E$12:$E$15

    Data validation List for cell N6 is(no quotes):
    "=INDIRECT(L6)"

    Steve

  3. #3
    New Lounger
    Join Date
    Mar 2002
    Location
    Netherlands
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Validation from Lists (Excel 2002)

    Thanks - did the job just fine

    Stuart

  4. #4
    2 Star Lounger
    Join Date
    May 2002
    Location
    Midland, Michigan, USA
    Posts
    133
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Validation from Lists (Excel 2002)

    Just for the record, you're not stuck. <!profile=Stuck>Stuck<!/profile> is stuck. Keep EXCELling.
    Smerdonk out.

  5. #5
    New Lounger
    Join Date
    Mar 2002
    Location
    Netherlands
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Validation from Lists (Excel 2002)

    Just for the record if I had been Stuck I would have written Stuck, however I had a problem and was stuck, so I wrote stuck. Some of us still know when to use capital letters.

Posting Permissions

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