#1   Report Post  
Old November 29th 04, 06:10 PM
Mike
 
Posts: n/a
Default Data Validation

Here's what I'm attempting to accomplish. I've asked this same question
several times but haven't found the solution yet.

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). Or I could do tables for the results, all on one worksheet. How
can I achieve this functionality, OR, is there a better solution to this?

Thanks!


  #2   Report Post  
Old November 29th 04, 07:01 PM
Mike
 
Posts: n/a
Default

I got it to work. The solution was given to me previously from crispbd as
follows:

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.

Thank you crispbd


"Mike" wrote:

Here's what I'm attempting to accomplish. I've asked this same question
several times but haven't found the solution yet.

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). Or I could do tables for the results, all on one worksheet. How
can I achieve this functionality, OR, is there a better solution to this?

Thanks!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation Window? Ken Excel Discussion (Misc queries) 1 January 11th 05 10:48 PM
Data Validation List =Name Pitbull Excel Discussion (Misc queries) 3 December 30th 04 06:43 PM
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? Arvi Laanemets Excel Discussion (Misc queries) 0 December 2nd 04 11:29 AM
Data Validation Formula Help Steve H. Excel Worksheet Functions 2 November 11th 04 09:38 PM
data validation on sth else [email protected] Excel Worksheet Functions 1 November 3rd 04 01:52 PM


All times are GMT +1. The time now is 12:36 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017