Hello all!

Another question, per usual. I've been tasked with finding out if it's possible to have two drop-down boxes in excel reference each other; that is, you select a value in one, and depending on the value selected in the first, the values listed in the second change. Any ideas on how I could achieve this?

Thanks!

~ Matt

Hi Matt,



Maybe... (attachment)

Martin

Hey, perfect! Thanks so much!

Hey, as an un-related follow-up, how do you limit an excel worksheet to only have a set amount of rows and columns like the example? I'd never seen that before...

The extra columns and rows are simply hidden

Select A10, Ctrl+[censored]+DownArrow.

Format=>Rows=>Hide.

Similarly for the columns.

For even better effect you can also hide gridlines (Tools=>Options=>View, Uncheck gridlines)

Martin