Quote Originally Posted by jgema View Post
The file would take really long to "strip it down" because I have some confidential information in it. I hope its ok to try and solve it simply by description...
No, it is not OK

Sounds to like you're trying to amake a dynamic drop list.

Have a look at the tutorial at the link below and see if it resembles something close to what you want to do.

http://excelsemipro.com/2011/05/a-dy...list-in-excel/




And as sidebar, is the Excel version shown in your profile accurate?