Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Vba Data Validation Macro


write a VBA macro that will check selected cells to see if their values conform to the corrosponding data validation rule?

I understand that data validation only checks the data upon entry. how to check all the cells or a selection of cells in a worksheet after the fact. I done a lot of editing and made changes to some of my validation lists and now want to know which cells no longer conform.


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Nested Data Validation: Figure A To Enforce Dual Data Validation On A Single Cell?
I'm trying to figure a to enforce dual data validation on a single cell. That is, I need to restrict the user to entering only a decimal value, only if a particular other cell (say A2) is blank. To put it another way, if A2 is blank, the user can enter a decimal value, but if A2 is not blank, the user cannot enter anything. I can use Data Validation to enforce either the decimal restriction or the ISBLANK, but I'm not sure how to make them work together.

View Replies!   View Related
Insert Data Validation Via Macro Code
I have written the below code to enter some formulas, validation, and formatting. I keep running into a problem when trying to add the first validation.
The debug msg is...

Run-time error '-2147417848 (80010108)':
Automation error
The Object invoked has disconnected from its clients.

Debug highlighted portion is...

.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=PRODUCT" ....................


View Replies!   View Related
Data Validation List To Select Worksheet In Macro
I have a Data Validation list in cell A1 of a worksheet called LIST. I would like to modify the macro that I have recorded, the macro uses data from various worksheets. I would like to sort out some code so that at certain points in the macro it will select the worksheet that is shown in cell A1 of the LIST sheet and then carry out the code already recorded. THis will allow me to quickly change a sheet name that is refererred to in the macro numerous times without actually manually editing the sheet name in the macro code.

View Replies!   View Related
Mouse Scroll WITHIN A Data Validation List & Option Macro Assistance
I'm trying to do a few things actually. I am somewhat a newb at programming, although I do understand how C++ and the coding works within Excel. To me, it's like the English language...knowing all of the vocabulary and formatting it right is important. If I don't know the vocabulary, I don't know what options I have.

This tool is being used in the call center I work in. It is to help eliminate repititious information used to notate accounts. I have attached a picture of what the tool looks like so you can have a better idea of what I'm working with. Here are a list of things I'm trying to do which I have searched and not found answers to:

1. I am trying to use a middle mouse scroll to scroll through validation list. This list information is located on a different locked tab. Basically, I have a few rows where a drop down selection can be made and it would be easier to scroll rather than manually moving the slider within the validation list.

2. As you can see, this "tool" an employee and I have created has many buttons. What I would like to do is to be able to click a button on the right and have it "stack" text within a single cell. In other words, if I click the button once, the text may be entered into the "actions taken" cell. If I click another button, I can have the option (or maybe a little "+" next to the button) to add this button's information to the end of the information already entered within the "actions taken" box. I've tried recording and using the keyboard and selecting "end" and then having the text added, but it didn't work. I've seen "loop" VBA code, but I don't want something to repeat, I want it to stack in the cell when clicked manually.

I'm sure there is a way to make the tool much better using VBA code and not use Excel, but I don't have an extensive knowledge of Excel to do something like that. I'm a very fast learner and understand how the coding works, so if you have an idea which may help, and you understand what I'm trying to do here, please provide your .02.

Basically, it's used so the Customer's name and phone number are entered manually, and then just about everything else is automated by the use of the buttons on the right. If I could get the 2 above options to work, it'd be perfect. I just figured out I could eliminate screen flicker and hide the macros working by using:

View Replies!   View Related
VBA Macro To Create Multiple Data Validation Lists From Variables & Named Ranges
I cant seem to find the correct syntax for creating 14 validation lists using array members as the source of the named ranged. The validation lists are stored on a different worksheet, the Named Ranges are created fine, as are the ranges that are having the validation applied. The Syntax I am having a problem with is

Public Sub assignDVList(WSD As Worksheet, sListName As String)
Dim DVListName As String
DVListName = "DV" & sListName
Application.Goto Reference:=sListName
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=" & DVListName

It is the Formula1:="=" & DVListName that is creating the headache. The sub is called as the array moves through the columns, using the header row as the Name for the Named Range, and the data Validation worksheet uses the same naming except it has DV in front.

View Replies!   View Related
Data Validation: Can I Use Data Validation In A Cell That Has Formulas In It?
I have attached a sheet that I am working on. I want cell G1 to be less than or equal to 165. That cell contains a formula. If the formula takes the number to over 165 the validation is allowing it.

View Replies!   View Related
Data Validation :: Selected From 4 Validation Lists
I would like to know if it's possible to populate a data validation list based on what is selected from 4 validation lists?

for example:
On sheet1:
If 'Group1' is selected from data validation list1 then data validation list5 will show a list of all items from Group1. If 'Group2' is selected from data validation list2, then data validation list5 will display all the items in 'Group2'...

(I do not want to use a combo box for this)

View Replies!   View Related
Use Data Validation That Will Pull Data From A Source List
Is there a way to use Data Validation that will pull data from a source list and also be able to type in additional data or just new data in same cell?

View Replies!   View Related
Data Validation; Get All The Data Row Wise For The Name Selected In The Drop Down
I have a excel sheet with values correcponsing few names. I have a list for a Data Validation drop down. How to get all the data row wise for the name selected in the drop down.

View Replies!   View Related
Data Validation List: Ignore Blanks Between Data
In column A I have a list of text. There are blank lines in between the cell that actually contain text. What I am trying to accomplish is create a validation list that will give me only the cells with text in them and ignore the blanks. For example in column A1:A7 I have the following text:

John
Mike

Tony

Jake

My validation list will return those names but will also give me the blanks in between the names.

Is there any way to ignore the blanks?

View Replies!   View Related
Allow User To Automatically Add Data To Data Validation List
I am trying to learn the concepts, then apply them to a set of actual worksheets. I am trying to use named ranges from one worksheet in another worksheet. The named ranges need to expand. Although I can get the add data to a dummy worksheet to work within the same worksheet and I can even get a named range to work in the foreign sheet.

My problem is, when I can end up adding the additional data to the named range, it will only add one name. I have a number of named ranges that are referenced on various worksheets. The idea is, certain named ranges should be able to expand so I donft have to type them all in. (There could be hundreds of manufacturers or models.) I would also like them to be able to sort themselves after additional names are added to the named ranges. I would also like them to auto populate as well. I am using Excel 2003 SP3 (11.8307.8221). I have enclosed the file. Drop down lists (named ranges) are on the worksheet called DROP DOWN LISTS (LOCKED) **ITfS NOT CURRENTLY LOCKED**.

The data validation issues are on the worksheet called Rev7.0 Wood (Basic Sheet.) There are other instances to use these, but I hope to learn to do them myself on the other worksheets. Of particular interest is Column f.................

View Replies!   View Related
Data Validation List With Changing Data
I would like to utilize data validation to create a drop down list from a list of 100 rows that changes monthly. Currently the list is set to draw data from A1:A100, however depending on the month, different cells will have data in them. What I don't like is currently the blank cells create gaps in the data validation drop down list and make it longer than it needs to be. Is there any way for excel to automatically just display cells with data in them in the drop down?


View Replies!   View Related
Data Validation :: Limit The Data Available On The List
have created a list obx using data validation. My question is, is there a way to limit the data available on the list.

Example: sheet 1
A1 A2 A3
Address A
address p
address s Date

Sheet 2
has data validation list that consists of all of A1 a named range called "address". Everything works great.
I now want to be able to limit the available choices in the list depending on what cell the user is in

example: if user is in sheet2 a1, i only want them to be able to pick address that have an "A" or "p" in cell A2 on sheet 1

I tried to acomplish this using conditional formatting, I format my named range with different colors, but the colors do not carry over to the data validation list on sheet2.

View Replies!   View Related
Data Validation Multiple Columns Data
about data validation drop downs.

I have 2 columns that need to be filled in once a name is selected from the data validation drop down. The data is to the right of the name in the source area.

Column A Column B Column C
1 Name 1 Skill 1 Phone #
2
3
4

This is the format, Every row in Column A has a Data Validation Drop Down, I need Column B and C filled with Data from the selected name from Column D (the data columns D-F)

Column D Column E Column F
1 Name 1 7 555-1111
2 Name 2 5 555-2222
3 Name 3 3 555-3333
4 Name 4 4 555-4444

So when I select say name 3...

Column A Column B Column C
1 Name 3 3 555-3333
2
3
4

View Replies!   View Related
Creating A Data Form With Data Validation
I have limited ability with Excel, and I'm trying to create a database using the Data/Form menu choices. My problem is I only want specific data in two of the 20 or so fields. When I use Data/ Validation and direct data entry, I get exactly what I want, EXCEPT that the choices don't come up when I use the Data/Form. Users can enter anything they want, which defeats the purpose. I tried to build a user form to use for data entry, but I don't know how to get it to add items to a database or lookup items like the data/form process does. I also want to add a few macro buttons to the form to do other things.

I am pretty sure of a few things: 1) This should be pretty simple. Anyone knowing VBA would probably know how to do this in minutes. I found some code that did a simliar function, but couldn't interpret it to fit my needs, which brings me to 2) I'll never use VBA or complicated macros again. I don't have the need for them. This is just an isolated incident. Therefore, signing up for a class would be useless to me. I tried to locate some advanced Excel/VBA classes, hoping to find an instructor or even a student who would welcome a simple challenge, but there are none available.

View Replies!   View Related
Navigating A Validation List Using A Macro
I have a workbook that contains a worksheet with commission data with a validation list of about 50 items. Each of these items represents a sales peron within my organization. Every month I select each of these items or sales people from the validation list (using the drop down box), which changes the commission data for each rep on the tab, then convert this to pdf to create and send each of these reps a commission statement.


View Replies!   View Related
Automatically Run Macro From Validation List
I want to do now is link the code below to a drop-down menu I have created on one of the sheets in the workbook. I created this list using data validation and declared this drop-down menu as MIndex and the values to choice from are 0,1,2.

Does anyone know how I can link this drop-down menu to the macro. So basically once the drop-down menu is activated run this macro.

Sub SumMonthlyVol()
Dim wSheet As Worksheet
For Each wSheet In Worksheets
Select Case UCase(Left(wSheet. Name, 2))
Case "AJ", "CJ", "PJ"

If (MIndex = 0) Then
wSheet.Range("L52") = "= SUM(R33C4:R50C12)"
Else
If (MIndex = 1) Then
wSheet.Range("L52") = "=SUM(R34C4:R50C12)" ......................

View Replies!   View Related
Autocomplete With Validation List Macro
I have seen this problem mentioned on other threads, but, didn't see the resolution. I got the below code from contextures.com's sample spreadsheet DataValComboBoxSheet.xls. When I press the tab or enter key, Excel crashes. This macro does exactly what I need which is to allow the user to autocomplete from a long list of validation values that come from another spreadsheet. The code causing the crash is the Select Case KeyCode statement when the keycode is 9 or 13. I am running Excel 2002.

Option Explicit

Private Sub TempCombo_KeyDown(ByVal _
KeyCode As MSForms.ReturnInteger, _
ByVal Shift As Integer)
'Hide combo box and move to next cell on Enter and Tab
Select Case KeyCode
Case 9
ActiveCell.Offset(0, 1).Activate
Case 13
ActiveCell.Offset(1, 0).Activate
Case Else
'do nothing
End Select ....................................


View Replies!   View Related
Paste Macro - Clipboard Validation
If the user clicks the button to do the paste special macro twice - the second time they get an error (I am assuming that the clipboard has been wiped clean and they need to go back and copy the data again). The specific error message is: "Run-time error '1004': PasteSpecial method of Range class failed".

What I would like to do is add code to the pastespecial macro that looks to see if there is something to paste - if not, I want to give my own message and not the default one.

View Replies!   View Related
Data Validation Min And Max
I have a valve in A1 of 5
I have a value in A2 of 1
I have a value in A3 of 2

In cell A4 using data validation
Min formula=IF(AND(A1=5,A4>=A3),)
Max formula IF(AND(A1=5,A4

View Replies!   View Related
Data Validation ..
I want to add a validation list to a spread sheet using a named ranged. Easy enough so far, but if the range only has two values which are repeated several (hundred) times - Yes & No - how can i stop the value appearing on the list more than once?

I'm open to other suggestions with this such as using list boxes etc, just so long as i can get around it without having to maintain a seperate spreadsheet of the values i would like to appear in my list.

View Replies!   View Related
Is Data Validation The Way To Go
I have 2 sheets in a workbook. The first sheet is 'working loads' and the second is 'completed loads'. I enter data into the 'working loads' sheet. When that row of data is completed, I mark a x into the 'completed' column, when I put the 'x' into that column it sends that row of data over to the 'completed loads' sheet.

This is my problem, when I enter data into the 'working loads' sheet into the 'Bill to" column, because it is not restricted it can be entered any way the user decides to enter it. When it goes to the 'completed' sheet, the 'bill to' is entered in 2 or 3 ways depending on how the user entered it in the beginning on the 'working loads' sheet.

I want the user to be restricted on how the data is entered on the 'working loads' sheet so that I don't end up with the 2 or 3 ways it was entered for the same client on the 'completed loads' sheet. I also need to add to the the list if it has not been used in the 'bill to' info as we get new clients weekly.

I currently am physically changing the 'bill to' info on the 'completed loads' sheet manually so that the client is entered only once, but as the year goes on the list grows as I might have 5000 rows of data with the same client entered 2 or 3 different ways.

View Replies!   View Related
Select Nth Item From Validation List Macro
I have a normal data validation box on excel, but I want to be able to navigate my way through it using a macro. I can select & opent the drop down list with the following
SendKeys "%{DOWN}"

but then an action like

SendKeys "{UP}"

Does not navigate itself up the menu as a normal keystoke would. Any ideas on how to solve this? Basically, I want to select a cell, open the drop down menu, select the first choice in it (so thinking SendKeys "{HOME}{ENTER}" ) all using a macro.


View Replies!   View Related
Save Macro Validation: If Error Got To Cell A1?
I have a command button that runs a save macro to which I added cell validation the message box comes up and what I want it to do is go to the cell that is blank

View Replies!   View Related
Run Macro Based On Validation List Choice
I'm looking for a method, vba macro or Excel code, to preform the following task:
In the C column the user chooses one of several options from a menu, let's call these options 1 - 10 (this part is already done). Depending on the choise, different things are supposed to happen:

For 1-9, the formulas for cell A - Q on the current row should be copied to the next row (but with +1 in row number in formulas of course).

For 10, 3 blank rows should be created (well they already are blank..), on the forth row down, A3 - Q3 should be copied exactly. On the fifth row, the same formulas thing that was created for choise 1-9 should be created.

Since the real xls-file is too big already and it contains some sensitive information, I can't attach it here, but I made a small and similar xls-file, that better explain what I want to do.

View Replies!   View Related
Data Validation With Filter
I have two tabs in one spreadsheet and I want to have the results chosen in one tab to filter in the other tab. So based on my drop down box result chosen in the first tab, I want the data in the other tab automatically filter only the result that was chosen.

For example, if I have the word "apple" in the drop down then I want all my data in the second tab to filter by "apple" in column B.

Is this something that would be possible?

View Replies!   View Related
Data Validation/Formula
I have a workbook with two tabs, the first tab "Query" is an Access query that pulls in call data from our phone systems. The second tab "Report" is a userform/report. This will be used by numerous people and has to be as userfriendly as possibly. Because our clients want the data sent this way I don't have a lot of room in changing the report itself.

Let me paint the picture, I have it so the user is able to select the month from a validation list I created in B1, when the month is selected is autopopulates each work day of that month in cells A13:A35. There are several (28 total) reports from different phone lines we have. So I have another validation list in cell B3 that has the name of each report we have. So in theory the user should select the month and report and the information will fill in and they can print that specific report off. The issue is this. I had used the formula =SUMPRODUCT(--(Query!A5:A25004=Report!A13),--(Query!B5:B25004=Aban_08),Query!E5:E25004). I'm trying to find total calls for specific lines for specific dates. The "Report" tab has information from January to current with all 80 different call lines (all named differently such as CDN_5700, CDN_5701). One report such as "Aban_08" actually pulls information from several call lines which is bringing me to my issue, I need one tab for the report, and be able to have the user select the different report, but each report pulls from multiple call line names. Again, I need (for instance) B13 (cell A13 is the date June 2) to pull all calls from the report tab for the date of June 2 with (for example) the names "CDN_5700","CDN_5701","CDN_5702".

View Replies!   View Related
List Data Validation
The idea is to create a liquor order sheet which takes items and prices from a liquor inventory workbook, which is part of the same file. i'm sure that you can do it all fancy with a macro, but unfortunately i'm not super experienced with excel. so i helped myself with what i know a bit -> drop down lists. I created an extra sheet which has 4 ranges on there... the liquor type (liquor, beer, wine), and the 3 sub classes for each type (red/white/blush/sparkling for wine, draft/import for beer and so on and so forth). On the inventory i named the range of all white wines "white", of all red wines "red" ..

On my order sheet i created a drop down list for type and created 2 more via "indirect" .. so when you select "wine" in the first one, the 2nd one will ask you for white/red/blush/sparkling and the last drop down then for the exact item according to the range on the inventory.

Hope what i did so far is understandable ^.^

Now my problem is that i want the unit cost to be copied when an item is selected. So you select "beer" in A1, "import" in A2, "corona" in A3... and the price for corona (which is written in a cell on the inventory sheet) should show up in A4.

I attached a screen of the inventory sheet so that you can see how it is structured.


View Replies!   View Related
Data Validation - Whole Numbers
how can I set a cell so that you can only type in 1 , 2 , 3, 4, 5

I know I can use the validation but people can just copy a cell and paste it over.

View Replies!   View Related
Data Validation Associations
I'll start by saying this is my first post and I'm a novice in excel.

I am trying to link the contents of one column with the selection chosen in a drop down menu of another.

Example: column 'A' , in worksheet "NAMES", has a data validation name of 'LINK" the data validation =LINK is specified for cell A1, in worksheet "SHEET1".

I want the cell 'B1' to automatically be associated with the same rows as 'LINK' but the data validation name is 'DESC'. Rather than have a drop down I want an automatic association.

View Replies!   View Related
Txtbox Data Validation
How can I validate data in a text box where the input should be 6 digits, and pop a text box message asking to enter 6 digits. Also How can I be sure (validate) they enter 6 digits not more not less?

View Replies!   View Related
Data Validation From A List
I have a workbook that uses data validation from a list.
The same list is used in several of the individual sheets.
Can one use just one list for different sheets, as I'm having to create separate list for each sheet, which when an overall change needs to be made it is easy to miss one.


View Replies!   View Related
Data Validation Against Two Ranges.
I'm trying to create a user request form. In one section of the form, the client will enter in a list of "Allowed Roles". These are roles that they have rec'd approval to use - these roles will span multiple applications. In a tab I've named Metadata, I've got defined ranges indicating the valid roles for particular applications. Want I'm trying to do is attempt to define a cell in the user form for one application that, using data validation, will present them with a drop down list of valid roles to choose. The stumbling block I'm encountering is that I need it to validate against "Allowed Roles" and the valid roles for that app.

For instance:

Allowed Roles range name could contain:
B1 B2 C1 C2 P2 P3 D1 D3 D5 M1 O1

Payroll Roles:
C1 C2 C3 C4 C5 M1 O1

The Payroll Roles (on the metadata tab) are static, not user alterable in any way, and in fact Metadata will be hidden. Allowed Roles will be entered into the form by the client themselves.

Can I use data validation to create a drop down to only allow the user to pick a value that appears in both ranges? So they couldn't select C1 (since it's an Allowed Role, and a Payroll Role), but not C3 (not an allowed roled), or D3 (not a Payroll role).


View Replies!   View Related
Data Validation And IF Statements
I’m a fairly basic excel user, I think I have a fair idea of what I’m trying to achieve.
I’ve tried to take the time to explain my query so if anyone is happy to help, I’ll definitely take the time to give a decent response.

I’ve broken it down abit.

Background

I’ve created a form for which users select a series of drop down boxes, as each drop down box has a value selected, the options available for the proceeding drop downs are filtered and the options then become limited.

In order, the drop down boxes are;
1. Select a Utility – the data validation source list is “utility”GasElectricity2. Select a Distributor List of 3 Gas Distributors the data validation source list is “ElectDist”List of 5 Electricity Distributors the data validation source list is “GasDist”If user selects Gas as a Utility as per dropdown list #1, then the option shown in “GasDist” validation source list will appear.

If user selects Electricity as a Utility as per dropdown list #1, then the option shown in “ElectDist” Validation source list will appear.

3. Select a Service the data validation source would be either “Eservice” or “GService”Special Read Investigation4. Select a Sub Type the data validation source lists are either “EReadSub, GReadSub, EInvestSub, GInvestSub”

View Replies!   View Related
IF Statement With Data Validation
I have a simple work book. Please refer to the attachment Book1.xls.

In B1, the data is limited (by Data Validation with a drop down List) to Yes and No.

I need to limit the range of data in D1 as, If B1 = Yes , then the value of D1 could be entered More or Equal to 51 ; and if B1 = No then the data entered into D1 should be Less than or Equals to 50

I prefer to do it with Data Validation.

View Replies!   View Related
Userform Data Validation
I have created a userform that has 8 text box's, I want to restrict the user to only enter a date in the following format dd/mm/yy.

View Replies!   View Related
Data Validation - List Box
Hello, could some one please help me with the following:

I have created a drop-down list for the range : C3:C65000 using Excel 2003 and Windows XP Pro. I did this using Excel's Data Validation Tool. The settings I used are as follows:

Allow: List
Source: =GROUPS
Check Box Ignore Blank is Ticked
Check Box In-cell dropdown is Ticked

GROUPS = GROUPS!$A$2:$A$29

Now all this works well, such that when I click in the cell range : C3:C65000, then a dropdown list appears - showing a list of all my groups.

However, when I click on any of the dropdown lists in this range, the width of the dropdown list is only as wide as the column. Column C has a width of 20.

What I need please is for the dropdown list to be as wide as the list of information showing in the dropdown list. If some one could please explain on how I can achieve this - that would be great.

View Replies!   View Related
Two Data Validation On The Same Cell
can i do two data validation on the same cell
the first one to make a list form Define name "Lists"
and the other to make sure the name is not repeated


View Replies!   View Related
Data Validation VS Combobox
I am using Excel 2007 and I've been working with a spreadsheet that utilizes several Data Validation to allow users to make different choices and depending on those choices the next options in line change. My problem is that I have so many different options, so long of formulas, that I run out of space to type in formulas in the DV source field. One way I get around this is to drop down to the next cell and start again, but I really need all the choices to stay in one row. Somebody suggested using VLookup, but I am not sure if that is the right path to take because a few of the final drop down choices have multiple options, and I'm not clear on how to use VLookup.

I am strongly considering using a Combobox Form Control or Combobox ActiveX control because, from what I have learned, they wouldn't be restricted by formula space. However, being fairly new to Excel I do not know what the codes would be to allow the comboboxes to change options based on previous selections. I've searched the message boards extensively and haven't been able to find an answer.

View Replies!   View Related
Data Validation Drop Down
I have a range in a worksheet named "Product3" that has data down to row 30 that is linked to drop down boxes on another sheet. I want to add data to rows 31-40 to also show up in the drop downs. How do I extend that range?

View Replies!   View Related
Data Validation, Drop-down Box
I want to do couple of things here.
1. put an empty field in a drop down box. If possible the empty field should be at the top from the drop down menu.
2. Update names in drop down box when I add names to the list

View Replies!   View Related
Data Validation And Balloon
code to have a data validation put into a balloon with the office assistent?

When the user enters in the wrong data, the office assistent pop up with a balloon says: "Error:" The "Retry and Cancel" button will be include as an option.

I have gone to this link, but the code is not visable
http://www.contextures.com/xlDataVal04.html

View Replies!   View Related
Data Validation Dropdown
i put together this code. it works ok in 97 (but not if a cell is changed in col A by validation dropdown which i believe is correct)

it works ok for me in 2007(either thro dropdown or direct input) but user with excel 2003 cant get it to work at all, named range "drop" is just A B C D and is used in data validation dropdown col A

View Replies!   View Related
Data Validation From Another Worksheet
I would like to impose data validation on Sheet1 row A. I have a list of values in Sheet2 row A. Is their an easy way to do this?

View Replies!   View Related
Data Validation From Table (Non-VB)
I'm building a workbook that has a tab for each department (sales, admin, tech, etc.) w/i a project. I also have an inputs and instructions tab where I have all of my lists and background info hidden.

Essentially, on each tab, the user will build a team for the project using drop down lists. The lists reference data on the inputs tab. This data includes a list of all of the titles in the company, as well as which department they belong to. I want the validation to be structured such that the sales tab drop downs only see sales titles, admin only sees admin titles, etc. I also need it to be dynamic in its drop down inclusions so that when I add/subtract titles, I don't have to reset the validation for new cell references. Below is an example of the what the reference data looks like.

Input Tab:

Col A --- Col B
Dept --- Title
Sales --- Rep
Sales --- Sr. Rep
Admin --- VP
Admin --- SVP
Sales --- Closer
Tech --- Analyst
Tech --- Developer

View Replies!   View Related
Cascading Data Validation
I am trying to use cascading Data validation, but I keep getting a ref error.

I have set up a Dynamic Named range called Claim_Type_1

This contains the following choices:
External_Meeting
Internal_Meeting
Attend_Training

I have then set up Dynamic Named ranges called "External_Meeting", "Internal_Meeting" and "Attend_Training"

On my sheet, I am using the following for the data validation:

Source formula "=INDIRECT(M7)" - M7 is the cell with the original validation

It then tells me "The source currently evaluates to an error"

View Replies!   View Related
Formula For Data Validation
iam looking for formula to display the condtion result .

i have spec in col B and tolerance in col C and col D ( +ve & -ve tolerance respectively) from col E to I ,observed reading data & col j for results.

i want to check the value of col E to I for B C D value n if entire 5 values are within spec then display "0" in subsequesnt col J else display "1"
OBSERVEDRESULTS.L.NOSPEC`+TOLERANCE`- TOLERANCE123451250.20.2262525.225.425.22100.20.2350.20.2450.20.25510.20.2

View Replies!   View Related
Data Validation In TextBox
I have a userform used to input vehicle information. To prevent any errors, is it possible for data Validation to be set in a listbox to accept upto 7 characters (both numbers and letters)

View Replies!   View Related
Data Validation Report
I have a workbook of about 30 worksheets which makes extensive use of Data Validation. Essentially, data entry cells is validated against values within some predefined ranges (there are 6 ranges in total).

I am preparing documentation for this workbook and would like to document the data validation being used. Is there a way to extract this information? Where/How is it stored?

View Replies!   View Related
Sort With Data Validation
I've found that sorting a column next to one which has drop down boxes set up in it, does not take the options for the drop down boxes (data validation ) with them when being re-arranged. Is there a way to make this possible, or an alternative format I should be using? see example:

If item 4 is the only one available from supplier 3, (As shown by the drop down box options) how do I sort by say, department, and still have the correct options on hand? Sorting by department, the items move, but the data validation info stays where it is, leaving the supplier 3 option for item 1, which is not correct.

View Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved