Validating different sheets from 1 location

  • Thread starter Thread starter blahone
  • Start date Start date
B

blahone

I have a workbook with 12 identical worksheets- one for each month. I
there any way I can validate cells using a drop down from a centra
location - preferably on a separate 'data' sheet?

I would just list out the valid data manually in the source field bu
the one cell I need for them to select a number from a drop down from
to 100 and it won't let me place that many numbers in there.

Thanks
 
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

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data Validation List from different sheet 1
Validations 1
Data validation list using filtered range 3
Data validation only works once 1
Validation drop down arrow list disappeared 2
Drop down Lists from a different workbook 1
Data Validate not working on a sheet 2

Back
Top