Validation,........how to use a list in another sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi my name is susy,

I wanted to know how can I make use of a list thats in another sheet
(sheet3) to validate a cell(in sheet 1).

I'm trying to make a drop down list with some options but if ome one else
does work in this sheetthey should not be able to delete it. That's why I
though of paste the list into another sheet and Hide the sheet which contains
the list. But it sems like I can validate a cell with a list in another sheet.
 
Name the source range in sheet3 and use this name as source in your
validation list!

Regards,
Stefi


„susy†ezt írta:
 
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

Dependent drop down dynamic range formula, off sheet. 7
using the =page! feature to transpose a row to column 0
Data Validation lists update orginal cell with list update 3
How to limit validation list 3
Count the columns from one sheet and paste it in another sheet 0
Lookup Function for Data Validation 2
using pulldown list with a list and autocompleet function 3
Locations of validation lists 7

Back
Top