Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    New York, New York, Lebanon
    Thanked 1 Time in 1 Post

    Data validation technquied in Excel 3003,

    Hello LoungersI need to figure out how to do the following:In column A I have a list of buildings. The entries come from s list and the cell had data validation on it.What I want to do is that in column B I want to have data validation based on how many floors are in the building chosen in column A.For example if I pick Main Office building in A, I want the cell in column. B have s validation list made op on the numbers 1-11, but if I pick MOB, then B will have a list from 1-5I am trying to avoid VBA, though it maybe a last resort
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    Thanked 342 Times in 335 Posts
    Check out the techniques at

    This should work for Excel 2003. I haven't got my time machine working so I can't test out the features in Excel 3003 yet [smile]


Posting Permissions

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