I think I'm after the same thing as the original author...
I'm constructing a spreadsheet for people to fill in.
I want them to choose from 3 headings: Banks,Commercial and Insurance, then in each heading, there are 6 different titles.
Is it possible for me to allow the user to select the heading they want, then the correct 6 titles come up under it? Can I use Data Validation for this? I've just learnt the basics. Or would I do the long-winded way and autofilter each titles instead (under the correct heading)?