Drop down list
 

how can i make a drop down list that contains names, and changes the values
of the formulas for that name?

Drop down list
 

The formulas would use the INDIRECT formula to use the name from the
dropdown list.

But not enough detail to make a guess.

Are the names defined names for ranges? Or maybe sheet names?

Post a sample of your current formulas and how you want them to react to the
names in dropdown list.


Gord Dibben MS Excel MVP

On Wed, 11 Mar 2009 13:27:13 -0700, Selko
wrote:

how can i make a drop down list that contains names, and changes the values
of the formulas for that name?