create a list base on another worksheet
 

hello community

is there a way to create a data list basing on another worksheet data ?

can somebody please help me on this

thanks


oldLearner57

create a list base on another worksheet
 

Create a named range on the other sheet
Enter that name as list reference in Validation box

HTH
--
AP

"tikchye_oldLearner57" a
écrit dans le message de news:
...
hello community

is there a way to create a data list basing on another worksheet data ?

can somebody please help me on this

thanks


oldLearner57

create a list base on another worksheet
 

I used your recommendation but when I enter the Range name (from another
worksheet), i got a prompt telling me that the Validating list must be from
the active worksheet ?

can please assist further

thanks :)
--
oldLearner57


"Ardus Petus" wrote:

Create a named range on the other sheet
Enter that name as list reference in Validation box

HTH
--
AP

"tikchye_oldLearner57" a
écrit dans le message de news:
...
hello community

is there a way to create a data list basing on another worksheet data ?

can somebody please help me on this

thanks


oldLearner57