data validation list

Hi all, Thanks for reading and hopefully helping! I have a slightly weird question and have been searching for hours for an answer, and so far, no such luck. I would like to be able to have two drop down lists that link by a formula, so that if a person wants to select either way, it will...

Hi all I wish to create a sum formula based on if statements and using dropdown boxes my worksheet has 2 headings A1 Staff B1 Time C1 Cost Row 2 onwards for Column A and Column B are based on dropdown lists A2 Dropdown list is CT, TA, AEN B2 Dropdown list is 1, 0.75, 0.5, 0.25 In C2 I want...

Ok, after two days of banging my head against my desk I turn to you, I have a data validation list drop down that references 52 columns and it works great. My problem is i need a cell to reference the data validation drop down and select the next selection from the drop down.......? Thanks, Zach

Using Excel 2010 in Windows 7 32-bit I am attempting to use a vba macro to generate a number of drop down lists depending on how many entries the user requires. Each entry consists of the entry number, a data validation list, and a dependent data validation list. and should look like: <TBODY>...

Excel 2007 Error: "The list source must be a delimited list, or a reference to a single row or column." How it currently works: User selects a two digit number from a list box located at D2. The formula below populates the listbox for E2 depending on what is selected in D2. Problem is when...

Hi everyone, I'm trying to create a workbook for my job and create multiple drop downs using data validation, but using a single source (another drop down as my trigger for my dependant lists). Here's my data: <TBODY> Investor</SPAN> Claim</SPAN> Fees due</SPAN> Amortization</SPAN>...

I have set up a drop down menu and added an input message for a number of columns. orginally the position of the message was directly under the selected cell. I have accidently moved the position of one cells message and now all other collumns messages are fixed to this new location. How can I...

on my sheet I am trying to make a drop down list for a date range. Now I would want my source data from sheet 'Weeks' and it would be filtered like so: 1st: in C5 a year would be selected in the weeks sheet, Weeks!B6:B41 is where the years are located (12 lines of each year - 2012,2013,2014)...

I'm working on an HR database for applicants. I need to create 2 drop-downs, the second dependent on the other. The first one lists the status of the interviewing process, such as "Interviewed" and "Not Interviewed". This range has been named InterviewingStatusQuery. I further named the...

Hello I have an issue that i have been playing around with my self for quite sometime now. I found a code that should work but for some reason it is not working and I haven't a clue why. Any help would be appreciated. Goal : Code that will take a drop list and modify the pivot filters on...

I have a VBA macro for Excel 2007 below that loops through a workbook and deletes a picture (shape) in a range at the top of each worksheet. The macro works fine until a cell which contains a seemingly unrelated data validation list on Sheets(1) is changed. The macro then repeatedly trips up...

I am trying to use data valadation and create a list on three different cells. I need each list to be different from what is chosen from the following list. Can you help. Would like to do this in code

Hello All, I have a hyper-linking or possibly a Data Validation question. I have Sheet 1, with a bunch of customer on it(Each customer has their own row). It also has some financial data on it as well, but not important. I also have Sheet 3, which is a Pivot Chart of all the customers on...

While creating drop down list in data validation, excel 2007 accepts unique NAME only. I have to use same NAME for different criteria, kindly help me to solve this problem.

I hope someone can help me with this or point me to a post about this. I wasn't able to find anything. :( I've figured out how to use DV Lists and Dependant Lists, but I'm unable to create multiple Dependant Lists (with varying data) to point to the value chosen in one DV List. I can't use...

Hi forum, I have a workbook with data validation on 8 columns that works fine, except for a couple of users (I think they are running Excel 2010). When they open the worksheet and file/save,all the data validation is removed. Before they open, for the columns in question, going to tab Data...

I have used Data validation in excel to create a list of Car vehicles. I would however like to type in the first letter of the vehicle and the list to go to the vehicles beginning with this letter. I have so many vehicles it would save so much time scrolling up and down. Your answers would be...

I am trying to create a drop down list that updates based on previous selections. When i say updates, i mean it deletes the selected information from an updated source list. For example: The source data on sheet 1 is: A2 Apple A3 Boy A4 Cat A5 Dog A6 Egg This are the column headings: Column C...

Hi everyone. I have a spreadsheet that users will have to populate. Some cells are totally locked, others are available for users to input data, others have data validation (lists). The first question: I want users to be able to Paste as Values in certain cells (ie, I don't want them to just...

I found a code to make a data validation dropdown list wider temporarily while the column is selected: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Target.Column = "15" Then Target.Columns.ColumnWidth = 20 Else...