Home |
Search |
Today's Posts |
#1
|
|||
|
|||
New ? Data Validation
I am using the following method for selecting items from two data validation
list within one worksheet and from the result of the selections (from both lists), activating a worksheet named as the results from the selections. For example, select "animals" from list 1 (contained in cell A1), then select "dog" from list 2 (contained in cell B1), click on FIND button and the result is activating (goto) a worksheet named "animals dog". Programming in VB for the FIND button is as follows: On Error Resume Next Sheets(Cells(1,1).value & " " & Cells(1,2).value).Activate Here's what I want to change. Instead of activating a separate worksheet for each possible results from both lists, I want to have it activate a master worksheet and have it point to a particular cell on that worksheet. I wish to build tables on the worksheet, each table representing each different possible results from both lists. Anyone have a solution? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Data Validation | Excel Worksheet Functions | |||
Data Validation Formula Help | Excel Worksheet Functions | |||
data validation on sth else | Excel Worksheet Functions |