Drop Down Menu

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a question here that may be a doozy. I am looking for a way to have a
list populate that I can choose from when another cell has a specific value
put in it. This may sound confusing but here is the project.

I am tired of handwritting workouts for clients, so I want to have a
template that will allow me to choose chest on monday and have a list that is
created next to it that I can choose from every workout that applies to
chest.

is there a way to do that?
 
The trick to this is to create your lists on a separate worksheet and name
the ranges. So in the case of Chest, list all your chest exercises in column
A on sheet 2, highlight them all and name the range as Chest. Do the same
with other areas in columns B onwards.

Finally, on your main sheet, choose the cell where you wish to enter the
exercise type (let's say that is cell A3). In cell B3, select
Data-->Validation and choose List. Then in the Source field type the formula
"=Indirect(A3)".

When you first enter this formula, you will get a warning message if cell A3
is blank. Just accept it. Now test it by typing "Chest" into cell A3 and
checking the drop down list in cell B3. You should see your list.
 
Hey great advice worked like a charm. thank you.

Dom_Ciccone said:
The trick to this is to create your lists on a separate worksheet and name
the ranges. So in the case of Chest, list all your chest exercises in column
A on sheet 2, highlight them all and name the range as Chest. Do the same
with other areas in columns B onwards.

Finally, on your main sheet, choose the cell where you wish to enter the
exercise type (let's say that is cell A3). In cell B3, select
Data-->Validation and choose List. Then in the Source field type the formula
"=Indirect(A3)".

When you first enter this formula, you will get a warning message if cell A3
is blank. Just accept it. Now test it by typing "Chest" into cell A3 and
checking the drop down list in cell B3. You should see your list.
Click to expand...
 
hi sentenna,

i have a 100 sheets in workbook and i would like to create a summary for
every specific cell value...

like in 1st sheet,cellF13=ako,2nd sheet,cellF13=ikaw,and so on up to 100
sheet in the same cell...

the result would be like this in another sheet:

1row = ako
2 row = ikaw
..
..
..
..100row = sino

thnx in advance for help...
 
Back
Top