Need help with drop down box and 3 columns

[bishop7262]

Hi,

I am having difficulty trying to figure this out. I have 3 columns.

Category (Column A)
TRX
TRX
TRX
DB
Med Ball
DB

Body Part (Column B)
Chest
Chest
Biceps
Legs
Core
Chest

Exercise (Column C)
Press
Pushups
Curls
Split Squat
Diagonal Chops
Chest Flies

I would like to have it where if I click the category I can then pick the body part and choose exercises for that body part. Or if I wanted to just click the Body Part I can pick all exercise related to that body part no matter what category it is associated with.

Thanks in advance

 

[rs2k]

Well, I have no idea about your exercises and body parts, or what you are actually after, but here is a link about cascading combo boxes which displays a certain criteria dependant on what is initially chosen;http://www.mrexcel.com/forum/showthread.php?t=32&highlight=cascading+combo+boxes

Sorry, if i'm miles away from what your after, but post back with a bit more detail,

Cheers
Colin