validated

Hi , i have a filter from a table. I would like to be able by pressing for example a button copy the cells value to a data validated cell. I’m struggling at the paste , paste special part where the cell is not taking the value. Seemingly it’s removing the validation rule too. Does anyone have...

I have a formatted table named Table1. I have a validated drop-down list in cell B2. Is there a way to link the value in B2 to Table1 so that the table is filtered by column 4 to the result of the value in cell B2? For example, the user would select "Apples" from the list in B2, and Table1...

Hello! I am running into an issue to turn a data validated cell into a string that matches the same date on another sheet in the same workbook. Currently I have my data validated cell as a drop down from 1/1/2019 to 12/31/2019 and on the second sheet it is an entire column from 2-366 for...

Dear Friends, A: I have a worksheet of " Offshore Weekly Crew Change of Staff". I have all names (40 Names) in the left most column with validated (Drop down list). I need an Excel function to take any value from the left side validated drop down value and bring the corresponding ROW vales at...

I have a spreadsheet which I am using vlookups. when I enter an item it will auto populate the product code into another cell. The content is also from a validated list, though has over 2000 products. is there a way of typing the start of a name to locate products that start with those letters?

Hi All Can someone please help me. in below table Column D is data validated only to have "won" or "fail" , I need a vlookup formula in column D which will look status of column A in column C and if it should result if it is Won or failed, if there is any other value other than won or fail it...

Hi, I inquired within another post here about utilizing a message box to search data in a sheet. It was recommended that I begin a new thread to ask questions as my questions differed from the OP's in that thread. Here is the question I asked in the other thread:

Hi, I would like to use a combination of a VLOOKUP and a validated list. e.g. the choices in the validation list are either "internal" or "external" (methods of delivering courses). The courses can be delivered either way but we have historical data which tells us what is the usual method...

Hi there, I am trying to create a formula in which a passing grade (A, B, or C) in a second semester math class validates a failing score (D or F) from the first semester. I have grades in two separate columns and want to add an additional column that checks to see if the semester 2 grade...