Who are my Excel Wizards
I am looking for assistance to create a specific drop down list. I have crated a cell that auto populates a book title based on the reference number I enter to the cell on its left. I would like the next cell to offer me a drop down list of the chapters of said book. I don't know the right language to use to get directions. I think it's a "dependent" drop down but that's as far as I get. Can anyone help? I can send a sample screen shot. I have started creating the chapter lists.
32 Views

I sent you an email, Allie.