I am creating a workbook that will contain several Named Ranges (I work for a publishing company and the ranges will contain journals under medical specialties [i.e., Gastroenterology, Cardiology, etc]).
I have used data validation to create a dropdown with the names of all the specialties (These would also be the names of the ranges). .
Is there a way to have Excel display the contents of the range that is selected from the dropdown?
I know I can use the INDIRECT function to creae another dependant drop down, but I am actually looking for the cells with the range to self populate once the selection is made.
Thanks in advance for any and all help you guys (and gals) can provide.
Thanks again
Rad
Bookmarks