Think this is what you're looking for, See wb..
PS: Your Combo Boxes will show blanks, which are actually can also be removed by adding another formula into OFFSET function. Notice that for the 3rd Drop Down, into OFFSET I used 5 as RowHeigh. Because it's constant it wouldn't change automatically. You will need to use another nested formulas to get rid off blanks in you drop downs.
Last edited by contaminated; 04-22-2011 at 04:22 PM.
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
Thanks Again! I really appreciate your time and insight. This looks much better and it is almost complete. H17 and G19 work perfectly but when you have "Int'lAIR" in cell G19 it does not populate any options in cell H19. Everything would be perfecto if we could get that part to functions. Thanks!
I figured it out. One of the cell groups had the wrong name attached. After I matched it up, everything works fine. Thanks again!
Originally Posted by contaminated
This post is old, it is closed, but still deserves a thumbs up! Thanks for the example, saved me loads of work!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks