how 2 select source of other wks in data validation list

[wavemehello]

Pardon my ignorance,

-Data-valiation-allow list-source-
(as my source is in other worksheet, excel does not allow me to click the source sheet ), what is the process to select it (without coping the source somewhere in the worksheet )?

 

[acw]

Hi

Try creating a defined name to cover the data and have the list refer to the defined name.



Tony

 

[wavemehello]

it worked after putting =in the range name in the source

Thank you! You are a star!