I'm creating a workbook for an exercise program for my clients that contains a printable template in one worksheet and a database of exercises in another worksheet. I have no problem creating a typical drop down list, however I have been unable to figure out how to (or if it is even possible) create a drop down list within a drop down list.

Let's say I've sorted my exercise database into 2 types of exercise: upper and lower body and I have 2 exercises for each type of exercise: Upper body: pushups and pullups, and lower body: squats and lunges.

Is it possible, in a single cell to first select upper or lower body and then once that is selected, the list changes to those exercises under my first selection.

ex. In A1, my goal is to select Squats. Is there a way to first select lower body from a drop down list and then the list changes so I can select squats in the same cell, A1?

Or is there a better way to do this?

Thanks.