Jenny has attended:
Excel Intermediate course
Excel Advanced course
Excel
I have been asked to create a form which will have 'drop-down' boxes to select different information. Is it possible when choosing one of the options in a drop down - that that option would then display certain information on the form below it. ie if you opted on a drop down for 'January' then certain information would display below but if I opted for 'February' then different information corresponding to that choice would display below. Hope I'm making sense. Is it possible? If you could come back by mid-day tomorrow that would be really helpful.
thanks
Jenny
RE: Excel
Hi Jenny thanks for your query and apologies for the delay. You'll need to do this with a mixture of Data Validation and VLOOKUPs, both of which were covered on the advanced Excel course. You can put a drop down list in a cell by using data validation. The form below will comprise of several VLOOKUPs, with the lookup value being the one the use selected from the drop down. The lookup will then retrieve related values from one other sheet. When it's up and running it works quite seamlessly.
There are walkthroughs of data validated lists here:
http://www.bettersolutions.com/excel/EGH188/QI215312022.htm
and lookups here:
http://www.bettersolutions.com/excel/EDH113/YI519060881.htm
Hope this helps,
Anthony
