[AccessD] OT: Excel input range

After a long day battling my way through this Excel development I am signing off for now but in case any Excel gurus have the time, could you answer this:

On an Excel s/sheet I have 3 combos (created with the form control). I have nominated an input range for each (on a separate sheet). Depending on the choice the user makes in Combo 1 and Combo 2, I need to modify the range for Combo 3. What's the best way in Excel? I see on lots of internet samples that quite often people set up range after range of values and nominate one or the other as the appropriate range when the combos change, but surely there is a more efficient way??

I have fairly simple rules from the client and I think that I should be able to set up a grid /range of cells which hold my criteria. I can post sample data if anyone thinks they can help.

Thanks everyone - and apologies for the Excel posts (I am also posting to Excel sites but no luck yet). Have a great w/end.


Kath Pelletti
Software Design & Solutions Pty Ltd.
Ph: 9505-6714
Fax: 9505-6430
sdssoftware at optusnet.com.au