Please can you assist, or point in the right direction.
I am trying to create a spreadsheet with multiple linked drop down options.
I have attached an example to hopefully give you a visual of my working.
e.g. starting off with only option 1 selectable. options 2, 3, 4... blank. if option 1 selects "sales" the option 2 presents the possible selections available for option 2.
Thank you in advance.
Alan
This is a pretty decent tutorial on it: http://www.contextures.com/xlDataVal02.html. I can't get files downloaded here at work, but with a little work, it would probably be possible to replace the Indirect(A2) bit with an Index/Match combo that isn't volatile. That usually only matters if your sheet is very large or complex, though.
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks