Do I use VBA, Pivot tables or Macros.

[arcplus]

My issue is located here.
https://www.dropbox.com/s/aatymk2gvhzahc9/trial.xlsx
I must create a front page that when I choose type of product, it will send me to classification of product then to supplier. The report has to show which employee has what skill level, eith needs training (red), trained (green) or expert (purple). I do not know what to create this in, do I use Macro`s, pivot table or VB.

 

[Oeldere]

This is what you're up to (I added 4 links to this subject)

Create multiple linked dropdown list in excel<o></o>
http://helpdeskgeek.com/office-tips/create-multiple-linked-dropdown-lists-in-excel/<o></o>
http://thefinch.wordpress.com/2008/02/09/excel-dynamische-afhankelijke-datavalidatie/<o></o>
http://www.contextures.com/xlDataVal02.html<o></o>
http://www.snb-vba.eu/VBA_Afhankelijke_validatie.html also in Englisch<o></o>