Lists From Different Tabs

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

Guest

I'm trying to use Validation on Sheet 1 to create a list. The data for the
list is on Sheet 2.

I've assigned the name "States" to the column on Sheet 2 that contains the
data for the list.

On Sheet 1, when using Validation for the list, when I enter "=States" in
the Source box, it says "A named range you specified cannot be found".

I tried entering = and then clicking on the tab for Sheet 2 but it won't let
me do that.

I'm probably missing something really simple.

Thanks in advance.
 
How did you define the named range("States")?

Type "States" (no quotes) in the 'Name box' (where the cell address
appears) and hit enter. It should select the 'States' range.

HTH
 
On Sheet 2, I've listed the states in Column A. I highlighted Column A and
in the Name Box I typed States. It accepted it fine.

That did it. I was naming the range in the box where the font is shown
instead of the box where the cell address appears.

Thanks for your help Toppers.
 

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 pulldown list with a list and autocompleet function 3
Drop Down with dynamic named range offsheet source list 14
Using drop-down lists 4
Dynamic name range for use in data validation 1
Validation list from Named Ranges 5
Excel Is this possible?? 3
Data Validation lists update orginal cell with list update 3

Back
Top