Using Validation list from other sheet

  • Thread starter Thread starter Fgomez
  • Start date Start date
F

Fgomez

I am trying to get a validation list from another sheet in the same file, is
this possible?.

Thanks

Fernando
 
Yes, but you need to name the range (insert<name>define) then instead of
=Sheetx!A2:A3 refer to the name i.e

=MyList
 
Thanks Peo

Peo Sjoblom said:
Yes, but you need to name the range (insert<name>define) then instead of
=Sheetx!A2:A3 refer to the name i.e

=MyList


--

Regards,

Peo Sjoblom


file,
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CONDITIONAL FORMATTING BETWEEN SHEETS 1
Macro for moving rows 3
Data Validation List controlled by Cell Value 6
Drop down list from index/match formula 1
Auto data entry 2
Print multiple sheets from a validation list 1
Data Validation List from different sheet 22
Data Validation: How to create a dynamic range in column A and use itfor a drop-down list 2

Back
Top