MrExcel Publishing
Your One Stop for Excel Tips & Solutions

scroll down lists

Posted by Riccardo Raciti on June 29, 2001 10:57 AM

I need help in building scroll down menus that when you choose the appropriate field it displays a new sheet that also contains deop down menus.
How can I do that?

Posted by Connie on June 29, 2001 11:59 AM

I think you can find what you need by looking at the answer to a similar question I posted here on June 8 (message 19521). The solution uses the HYPERLINK function and a VLOOKUP table. Very clever solution. If you need help with it, let me know. It worked great for me.