List

[Guest]

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,

 

[Frank Kabel]

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

 

[Guest]

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




.