Hi!
I am trying to develop an Excel report, in which I cannot use VB and Macros. In this report, the user has 3 parameters to enter: the factory number, the sector and a machine name. Each of these parameter needs to be in a drop down list. So, when I pick a factory number, the next drop down list for the sectors is only going to show the proper sectors. As for the third parameter, only machines associated with the previous sector are going to be displayed.
I'd like to create a list of factory numbers in a different sheet, and next to it, a list of the sectors for the first factory. Next to that list, I would have a list with the sectors machines, and so on, for every factory numbers. For each of those list, I would then define an Excel Name. To identify each list, I would use a concatenation of the previously chosen parameters. The result of that concatenation would be a hidden cell. In essence, when I choose a drop down list, the source would be the cell with the parameters concatenation, which would actually be a reference to a defined Name associated with the right list.
I tried a test: I defined a Name called TOTO, which points out to a list of 3 cells. Next, I wrote TOTO in a different cell (let's say A1). Finally, I went in an empty cell (D1) to create my drop down list, and in the source section I wrote =A1. Instead of having my list of 3 elements, I obtain a list with a TOTO string... Is there something else I have to do in order to create dynamic Names, or does Excel just won't support such a thing? Thanks for the support!! (By the way, I use Excel 2003)
Yanick
Bookmarks