create a list base on another worksheet

  • Thread starter tikchye_oldLearner57
  • Start date
T

tikchye_oldLearner57

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
 
A

Ardus Petus

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

HTH
 
T

tikchye_oldLearner57

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 :)
 
Top