Data Validation
 

I'm trying to use Data Validation "List" for the following:

In cell (A1) is List 1, in cell (B1) is List 2.

Function:
Make a selection from List 1, then a required selection from List 2. The
results of combined List 1 & 2 point to a separate worksheet (either in same
workbook or separate workbook), specifically defined by the results from List
1 & 2.

Is this possible, or what are the alternatives?

Mike,

I'm not sure I understand what you're trying to do, but maybe this is it:

I created 3 excel files Book1, Book2, Book3.
In Book1 I have a validation list in A1 that contains, Book2,Book3
I have a validation list in B1 that contains A1,B2

In Cell A4 (Book1) I have the following formula:
="["&A1&"]Sheet1!"&B1

Then in Cell A5 I have this formula:
=INDIRECT(A4)

Now, what happens is that the selections in A1 and B1 change the result in A5.

Art

Here's what I'm attempting to accomplish:

In workbook 1 on worksheet 1 I have a data validation list in cell A1 that
contains school semester terms, i.e., Fall 2004, Spring 2005, Summer 2005.
On the same worksheet, I have another data validation list in cell B1 that
contains courses, i.e., Math, History, Science, Art. I want the user to make
a selection from cell A1 (list) then (if possible) required to make a
selection from cell B1 (list). With the results in both cells A1 and B1, for
example, Fall 2004 Math (Fall 2004 + Math), to point to (activate) a
different worksheet (either in the same workbook, or a separate workbook)
that is already created specifically for Fall 2004 Math. In other words,
there would be a worksheet for each possible combination from cells A1 and B1
(lists).

"Art" wrote:

Mike,

I'm not sure I understand what you're trying to do, but maybe this is it:

I created 3 excel files Book1, Book2, Book3.
In Book1 I have a validation list in A1 that contains, Book2,Book3
I have a validation list in B1 that contains A1,B2

In Cell A4 (Book1) I have the following formula:
="["&A1&"]Sheet1!"&B1

Then in Cell A5 I have this formula:
=INDIRECT(A4)

Now, what happens is that the selections in A1 and B1 change the result in A5.

Art