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

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.

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.

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)?

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)?