data validation list form sheet

D

dlotz

I have the list on sheet to.
When use data validation it will not let me
selct sheet 2.
I have tried to input
='SHEET',a1:a20

does not work
Plesae advise
 

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

Data Validation lists update orginal cell with list update 3
Need to display price in $ or £ dependant on supplier 6
using pulldown list with a list and autocompleet function 3
Usage of Data Validation with If Condition 4
Copying cells from one sheet to another 5
Remove blank cells from data validation drop down box 3
Lookup Function for Data Validation 2
Validation list from Named Ranges 5

Top