Get instant live Excel expert help to learn how to add data validation in excel

I want to prevent overwriting by copy pasting into the cells containing Data Validation, which is rendering it useless. I dont know how to use VBA in excel Please help stepwise thanks

I created 5 tables from one and reference them using data validation: "=IF(H4="Paving",PDescList,IF(H4="Iowa",IDescList,IF(H4="Nebraska",NDescList,IF(H4="NonDOT",NonDescList,IF(H4="Rebar",RDescList,"der")))))" i select the table from a list, now i want to reference the tables selected and get information for the item selected in the referenced lists.

Hi I want to create drop down list (data validation) and when I pick from this list I want my selection to have a corresponding number somewhere else on the spreadsheet. Please help!

I have a sheet with a data validation column, how do I use this data to create a pie chart? In this case, the sheet is a list of people and the drop down data validation lists where they are from - how can I create a pie chart to show all the locations where everyone is from so we can get an at-a-glance view of how many people are in each region. Thank you!!

I have created a spreadsheet with a dependent data validation drop down list, is there a way that I can copy the validation drop down as I want to use this for each row. If I select Airframe in the 1st row, the dependent drop down will show Fin, Tail, Elevators etc. I might have the row below with Prop which would have a dependent data validation drop down of Blades, Spinner. I want to carry out this task for multiple rows therefore currently I'd use this formula in cell E1 =INDIRECT($B$1) to get the value Airframe from the 1st drop down which will display Fin, Tail, Elevators. For the next row down, I'd need to use =INDIRECT($B$2) and so on for the next row. Is there a way to copy this subtle difference down the rows as it is in the data validation cell?

Can we create Dynamic dependent list while using data validation in excel. Can anyone help me?

I need to incorporate data validation into the following formula: =IF(C2="Credit Contract Agreement Unsigned",INDEX($D$2:$D$934,MATCH(CONCATENATE(B2,"Credit Contract Agreement Signed"),$E$2:$E$934,0)),"") Column F has a date 14 days after the loaded date, and I need to ensure that whatever result date for a signed is pulled falls within those two dates.

make cell x = cell y when data validation in cell z is one of two options

I have a column with data validation on it for the =NOW() formula. I need a formula that can count the number of times listed within a time range. The output i am looking for is excel count number of cells between "3:00PM and 3:30PM."

Hi, in my Excel attached I would like to use a combined data validation. On Sheet 1 Column C, Cell C2 I validated 3 main categories which you can find on the Sheet 2. My problem what I would like to solve is that, if I choose a category in Column C, Cell C2 (eg.: Reviewer issue), after in Column D, Cell D2 to have in the dropdown only the elements which are coresponding to this Subcategory, and no matter which Category I am choosing in C2, in D2 I will get only the elements which is corresponding to that specific Category. Thank you in advance for your help!