Data Set:Sheet1 (Table 'Alpha' on Sheet1!A1:B200)
-ColumnA: Employee_Name (sorted A-Z)
-ColumnB: Qualification_Code (01A, 01B, ..., 01Z) (Each employee has a single Code, but multiple employees have the same Code)
-ColumnB: Position_Code (01A...
I have a table with the following columns: Account, Sub, and Split. I'm trying to create cascading data validation lists where you first select the Account, then the Sub, and finally the Split. So in the table below if I chose Account = 501650, then Sub = 00-240, the third Split list should...
I'm having difficulty in creating a drop down menu thats dependant on the 1st drop down.
For example, I have a list of product lines, Regulatory Compliance, Anti-Fraud, Financial Custom, Financial Control.
I have a separate list of the items that relate to Regulatory Compliance, Anti-Fraud...
I have a workbook where users can input job titles in two different ranges (A2:A6 & A8:A12). Only one range would be filled at a time, but I want to use one data validation list for both ranges without blanks showing up within the list. The problem is if I use formulas to generate the range for...
What I have:
Sheet 1 has a list of tank_id's (no duplicates) called "Details" (Columns are Tank_id, Tank_Name, Nation, Turret, TArmor_front, TArmor_rear, TView_range..).
Sheet 2 has a list of Turrets and the specifications called "Turrets". (Columns are: Tank_id, Turret_id, Turret_Name...
Hello, I am looking for a way to reset all my dropdown lists in a workbook to their top choice. Right now I found the following code, but it is for a certain sheet only, whereas I want all sheets with a dropdown to do this. plus I want this to only work when the sheet is opened automatically...
I am using EXCEL 2013 and am trying to find out if there is a way to auto-update the consolidate function. I am using a vlookup based on a data validation and would like to consolidate the result automatically when the value in the validation cell changes. I can't post the worksheet here for...
I created a drop-down list with different fruit names and I want the user to be able to type in the first couple letters of the fruit name and have it auto-populate. For example, if the user types in "ap", the word apple would automatically appear. Is there a setting within the data validation...
I have a excel sheet and i have created a data validation function. Its a conditional dropdown but I can not input my equation in data validation field. Its says too many arguments. My equation is
=IF(A4="Capital",'New List'!$C$2:$C$42,IF(A4="Pier Caps",'New...
When I use inside a data validation (list) the expression: Offset('Sheet1'!$E$1,0,0,COUNTA('Sheet1'!E:E),1) I get the correct list.
I also have that expression as a text in the cell A1.
When I write the expression in the data validation (list) =INDIRECT(A1) I get an error and no list is...
I am trying to create a data entry worksheet that includes a data validation list based on Index/Match values from our Purchase Order Table. I have used data validation to create a drop down list for the PO, and I am trying to create a second drop down list based on matching...
Losing my marbles with this now.....:(:confused:. I have been trying to work out a way to filter on Data Validation. I:E On one sheet I have all my data and the separated by 5 different categories.
This is my first time posting a thread but a few years following yours.
I have the following code which I can't make it work. It works when its refer to a single cell but it does't works when I use a named range. I have a named range "TGCEne" in the active worksheets with data...
Hello - I am looking for a way for my drop-down list to only display certain options based on a drop-down of another area. Essentially, I am looking at a Function vs. Subfunction. I want my data to be tied firstly to the function drop-down. Let's take for example:
Function (and sub-functions...
I have a table containing education assessment data and need to use the data to analyse a child's data on another worksheet. So far I have set up 3 drop down boxes that contain 'First Name', 'Surname', 'Class'.
I have set up these to look at the fields in the table but I would like it so that...
I am trying to change the color of a tab based on the cell value in B5. B5 is a drop down list using data validation that contains four entries: "Flow Rack" , "Workstation" , "Machine Guarding" , and "Other (custom)". A tab is named after each one of these as well. If someone selects...
I have a list on a separate sheet that I am wanting one particular cell to autocomplete from. I have searched for quite some time on a resolution to the issue.
I have even placed the list above the cells I am working with, and then hiding them, but after I am finished with my current task I...
Dear Excel Guru’s
I’m struggling with one of my last tryouts in Excel Macros.
I would like to have in my sheet combination of Data validation list & Vlookup. But I want to have it in Macro, so user won’t be able to see formulas, delete, edit etc..
I succeed with stand-alone Macro (what was...