Data Validation
 

I have a data validation list in cell (A1) and another list in cell (B1). I
would like to select from the list in cell (A1) and then select from the list
in cell (B1) and have the results of both lists point to another specific
worksheet defined by the results in the two lists all within the same
workbook. Is that possible?

Sure you can- could you give me an example of how you'd like to
incorporate the two lists?


--
crispbd
------------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880
View this thread: http://www.excelforum.com/showthread...hreadid=319799

You may want to explore the INDEX and MATCH worksheet Functions
This site has some good info:
http://www.contextures.com/xlFunctions03.html

tj

"Mike" wrote:

I have a data validation list in cell (A1) and another list in cell (B1). I
would like to select from the list in cell (A1) and then select from the list
in cell (B1) and have the results of both lists point to another specific
worksheet defined by the results in the two lists all within the same
workbook. Is that possible?

Example:
I have a list (data validation list) of semester terms (i.e., Fall '04,
Spring '05, Summer '05) and another list of courses (i.e., Math, Science,
History). I want to have whatever I select from the two lists, for example,
Fall '04 + History, to then "goto" a worksheet that contains information
pertaining to Fall '04 History only. I would make a worksheet (or separate
tables in same worksheet) for each possible combination from the two lists
with their respected information. Does this help explain better what I'm
wanting to do?

"crispbd" wrote:


Sure you can- could you give me an example of how you'd like to
incorporate the two lists?


--
crispbd
------------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880
View this thread: http://www.excelforum.com/showthread...hreadid=319799

Do you mean that you would like the workbook to navigate to the target
sheet, or just retrieve data from that sheet?


--
crispbd
------------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880
View this thread: http://www.excelforum.com/showthread...hreadid=319799

If you just want to navigate to a selected sheet based on the 2 list
items,
try this:

Given: Cell A1 has the semester, Cell B1 has the Course

1) Goto View:ToolBars:Control Toolbox
2) From the Toolbox, click the button icon,
3) draw a button on this sheet
4) double click it to go to the VB code,
5) paste this into the button's code:

On Error Resume Next
Sheets(Cells(1,1).value & " " & Cells(1,2).value).Activate

This will activate the sheet which is the combination of the semester
(plus a space) and course: "Fall 04 History" for example, if Fall 04 is
in one list, and History is in the second list.


--
crispbd
------------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880
View this thread: http://www.excelforum.com/showthread...hreadid=319799

To navigate to the target sheet (or table) would be ideal. But if that is
not possible, then to retrieve data from another sheet (or table) would be
okay.

Also, do you know if you can required "selection" from the second list once
a selection is made from the first list? And if so, how? Is Data Validation
List the best method of doing this, or is there another preferred method. I
was just trying to save desktop space and have the page look nice, thus the
reason for the drop down lists using Data Validation List.

I know this would be better achieved using Access but I don't have that
option.

"crispbd" wrote:


Do you mean that you would like the workbook to navigate to the target
sheet, or just retrieve data from that sheet?


--
crispbd
------------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880
View this thread: http://www.excelforum.com/showthread...hreadid=319799

Okay, I've done what you've instructed but I don't see any results, or
exactly what I'm supposed to see. Did I leave a step in the process out.
Here's what I've done so far.

On one worksheet, I've created two data validation lists. One in cell (A1),
the other in cell (B1). In these lists are data, one with semester terms,
the other with courses. I have not recreated the separate worksheets for
each possible options from the two lists combined yet. I did create the
button you suggested, but what now? Sorry, I'm not a guru at VB... LOL

Thanks for your help.

"crispbd" wrote:


If you just want to navigate to a selected sheet based on the 2 list
items,
try this:

Given: Cell A1 has the semester, Cell B1 has the Course

1) Goto View:ToolBars:Control Toolbox
2) From the Toolbox, click the button icon,
3) draw a button on this sheet
4) double click it to go to the VB code,
5) paste this into the button's code:

On Error Resume Next
Sheets(Cells(1,1).value & " " & Cells(1,2).value).Activate

This will activate the sheet which is the combination of the semester
(plus a space) and course: "Fall 04 History" for example, if Fall 04 is
in one list, and History is in the second list.


--
crispbd
------------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880
View this thread: http://www.excelforum.com/showthread...hreadid=319799

Can you explain in more detail please?

"crispbd" wrote:


If you just want to navigate to a selected sheet based on the 2 list
items,
try this:

Given: Cell A1 has the semester, Cell B1 has the Course

1) Goto View:ToolBars:Control Toolbox
2) From the Toolbox, click the button icon,
3) draw a button on this sheet
4) double click it to go to the VB code,
5) paste this into the button's code:

On Error Resume Next
Sheets(Cells(1,1).value & " " & Cells(1,2).value).Activate

This will activate the sheet which is the combination of the semester
(plus a space) and course: "Fall 04 History" for example, if Fall 04 is
in one list, and History is in the second list.


--
crispbd
------------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880
View this thread: http://www.excelforum.com/showthread...hreadid=319799