Newbie question: show value from drop down in another sheet
 

I've created a drop down list (e.g. Drop Down 4 in the "Data" sheet)
with some textual values in it. I would like to show the selected text
value in some cells on varios sheets, like in a cell og the "Jun"
sheet... How can I do this?
regards,
Ladyhawke

Newbie question: show value from drop down in another sheet
 

You need to use Format Control, where you can then specify Input Range and
Cell Link.
The Cell Link is the one you need. This will display the index no of the
item in the drop down currently selected. You could then use VLOOKUP or
INDEX on your other sheets to retrieve the actual item selected in the drop
down.

Newbie question: show value from drop down in another sheet
 

How would Index or vlookup be used on the other sheets and are there
nop option to avoid storing the data once more (linked cell)?

Martin Brader skrev:

You need to use Format Control, where you can then specify Input Range and
Cell Link.
The Cell Link is the one you need. This will display the index no of the
item in the drop down currently selected. You could then use VLOOKUP or
INDEX on your other sheets to retrieve the actual item selected in the drop
down.

Newbie question: show value from drop down in another sheet
 

Got index to work with named cells. Just out of curiosity: how do I
reference a cell in a sheet, so I can copy values from other sheets?

regards,
ladyhawke

ladyhawke skrev:

How would Index or vlookup be used on the other sheets and are there
nop option to avoid storing the data once more (linked cell)?

Newbie question: show value from drop down in another sheet
 

worksheets("House").Range("B9").Copy Activesheet.Range("F2")

--
Regards,
Tom Ogilvy


"ladyhawke" wrote:

Got index to work with named cells. Just out of curiosity: how do I
reference a cell in a sheet, so I can copy values from other sheets?

regards,
ladyhawke

ladyhawke skrev:

How would Index or vlookup be used on the other sheets and are there
nop option to avoid storing the data once more (linked cell)?