data valadation

Hi, I am not sure whether this has been covered anywhere else but here's my query. I am trying to make a table in which change a list’s values based on what is selected in another list. For example: Row A2:A100 has all the employee names (these are unique values) and B2:B100 has names of...

Hello, I am attempting to create a drop down list (data validation) and depending on what the user selects I would like have another cell run a calculation summing different values based on that selection. Unfortunately there are too many choices to warrant doing a simple IF statement so I...

hi, I have defined name in excel like: Named: My_CARS Refers to = My_Cars!$C$2:$C$100 Now in sheet2, I I'm doing in field A2 data validation and set up to Validatation Criteria as: - Allow = List - Source: = My_CARS. But I have all values - with duplicates. How can I get only unique values?

Hi All, I have a problem where I'm trying to find a formula for the following and don't know if I need to use a V-lookup, an IF statment or something else. I'm basically trying to say ; Sheet 1 A B C 1 From To Date 2 J330 J310 10/05/13 3 J330 J310 10/05/13 4 J330...

Hi All! I'm new here so please forgive any of the stupid things I might say :) I'm trying to create a macro that goes thru all the cells in a row, double clicks them and goes on to the next cell (all the cells already have values in them). When I record this then this is the code that is...

Hi Guys. What I am trying to achieve: A Single form to create quotes and orders, with a cell that generates a random quote number each time the form is amended. The quote number must be different if an amendment has been made to the document. The quote number needs to then become a static fixed...

I've been trying to figure out this all day basically. Please see attached file. <tbody> Game Type Day of Week Day Before Day Of Day After Basketball Monday -1 5 4 Basketball Tuesday -5 5 4 Baseball Tuesday 10 5 4 Hockey Wednesday -1 6 4 </tbody> 1) I need help creating a data...

I am doing a membership formula to calculate their rate they pay and how much they have paid to total out to how much they still owe. We give a 10% discount if have purchased a memership before the new year. <TBODY> e f g h i j 6 Rate type full price 10% discount customer price paid owe 7...

I had the great idea of changing some of my named ranges to Dynamic Ranges. I did not research this before doing so, now nothing shows up in my drop downs. All I have in the Data Valadation Source Box is =INDIRECT (I28) I have read that Dynamic and Indirect dont go together. If someone could...

Hi Y'all! Really simple question for you all, but its baffled me! Using data vaildation, I have created a dropdown box, which works perfectly, however, I used to be able to double click on the cell, and it would drop the list down (rather than clicking on the drop down arrow in the corner)...

I need for Example: if J4 has data in it then there must be something entered in K4 or a message box will appear saying" MK# Must Be Entered") and if there is data into K4 there must be data entered into J4 or a message box will appear saying" Drawing Must Be...

This is probably easy for your Excel genius' I have made a data validation drop down list that SHOULD update for when more values are entered into the column being referenced with an offset function =OFFSET(Data!$AR$6,0,0,COUNTA(Data!$AR:$AR)-5) the problem I am having is that Column AR has...

I asked something similar before , but I did not get a response. I'm looking for some guidance. I want to press a button and get a 2 column list, first column NUMERICAL (3 or 4 digits), 2nd column STRING ( aprox 20 chars ), I want to select a row and have the numerical value entered into the...

I am working on a project where I have list of tasks in column B. (This can be a few dozen or several hundred depending on what is going on) In columns C,D,E I have a 'key phrase' or 'value' assigned to each task. For example the first task is scheduling employee requests. I would put that in a...

I am working on a project where I have list of tasks in column B. (This can be a few dozen or several hundred depending on what is going on) In columns C,D,E I have a 'key phrase' or 'value' assigned to each task. For example the first task is scheduling employee requests. I would put that in a...

my data in Table Format... Column A = List of Countries Coulmn B = List of Provinces/States Column C = List of Towns On my report table, I want to use or apply validation such that when I choose a country, only the list of provinces from that particular country appears on the dropdown list...

ok, what I am trying to do is have three independent list i need the list 2 to be determined by the 1st one. Thanks for the help One more thing, I need a video or a link explaining how to have a data valadation list inside another one.( one drop down and then after choosing another drop down...