Validations

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

how do i set up list validations placing the info for the drop down in one
sheet and the drop sown boxes in other sheets in the same workbook?
 
Set up your list(s) on a sheet. Select all of the entries in a list and give
the group a name by typing a name into the 'Name Box' and terminating that
with the [Enter] key. The 'Name Box' is the box at the left of the formula
bar that usually shows the cell address of the cell on a sheet you have
selected.

Then on other sheets where you want to use a list for validation, when you
get to the dialog box, choose "List" for type of validation to ALLOW and in
the SOURCE entry type
=ListName
where ListName is one of the names you used to name a given list.
 

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

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data validation list using filtered range 3
lost the drop down list (the validation still exist) 4
Drop Down List Problem 1
problem with drop down lists 1
Copy dropdown list 1
Validation list in data entry form 4
Data Validation - Cell Colour 3

Back
Top