Drop down list

S

Selko

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

Gord Dibben

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
 
Top