List

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

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,
 
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
 
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




.
Click to expand...
 
Back
Top