Drop down list

  • Thread starter Thread starter Selko
  • Start date Start date
S

Selko

how can i make a drop down list that contains names, and changes the values
of the formulas for that name?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Drop Down List Contains the List Header Row 1
Filter a Drop List ? 1
Excel Excel: How do I put a formula in a drop down list 11
Conditional Drop Down List 1
Drop-Down List 3
drop down list should remember selection. 6

Back
Top