List

Hello,

I am trying to create a list in a cell that references a
name range on another sheet. The only way I know how to
create a list currently is to reference a fixed range on
the current sheet. How can I do this? Thank You,

Hi
on your other sheet select the range with your values. then goto
'Insert - Name - Define' and assign a name for this range. e.g.
'listdata'
Now goto your other sheet and goto 'Data - Validation - List'. Enter
the following as datasource:
=listdata

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
Hello,

I am trying to create a list in a cell that references a
name range on another sheet. The only way I know how to
create a list currently is to reference a fixed range on
the current sheet. How can I do this? Thank You,

Thank You



-----Original Message-----
Hi
on your other sheet select the range with your values.
then goto
'Insert - Name - Define' and assign a name for this
range. e.g.
'listdata'
Now goto your other sheet and goto 'Data - Validation -
List'. Enter
the following as datasource:
=listdata

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
Hello,

I am trying to create a list in a cell that references a
name range on another sheet. The only way I know how to
create a list currently is to reference a fixed range on
the current sheet. How can I do this? Thank You,

.