Get instant live Excel expert help to learn how to add data validation in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need to have two sets of Data Validation on a Cell.
Solved by T. A. in 11 mins
I need a way to apply dual sets of data validation to a cell.
Solved by A. D. in 30 mins
I need a formula for Data validation that is dependent on two other cells.
Solved by S. Q. in 29 mins
Helper column, data validation excel list to make colours into different sheets, was with an expert about a minute ago and session ended!
Solved by V. F. in 13 mins
Hello, I have select cells with data validation that I need to protect from being copy/pasted over. I've researched this and it looks like this must be done through VBA code. If it's much easier, I don't mind making the entire sheet/workbook protected from copy/paste. Can you provide a macro for this? Please note that on my work computer Google Drive/the uploading of a file does not work for your site. I've had experts provide code line by line in the past. Thanks!
Solved by V. H. in 17 mins
Can you please help write a macro that would prevent copy/cut/pasting on cells that have Data Validation in them?
Solved by D. D. in 12 mins
The workbook (not created by myself) have several cascading lists. B85 is dependent on G83, G83 dependent on B83, B83 is dependent on G10.
G10 and B83 work fine, and populate G83 correctly.
But depending on which option is chosen in G83, B85 may or may not populate. (specifically #s 8, 18, 19, 22, 23, 26, 28, 33, 34, 36 will populate nothing in B85).
When checking the data validation in B83:
=INDIRECT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($G$10, " ", "_"), "(", "_"), ")", ""), ",", "_"))
When checking data validation in G83:
The selection contains some cells without data validation settings. Do you want to extend data validation to these cells?
If yes:
=INDIRECT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($B83, " ", "_"), "(", "_"), ")", ""))
But if click OK:
The source currently evaluates to an error. Do you want to continue?
The data validation for B85:
=INDIRECT("_"& SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LEFT($G$83, LEN($G$83)-1), " ", "_"), "(", "_"), ")", ""), "/", "_"))
Please help!
Solved by V. U. in 21 mins
I need data validation to work down multiple rows and I only know how to do it one at a time. On the sheet you will see: Space, Item, Quantity,Item Total $, Total Job Cost. I have figured out how to use data validation to make the dropdown lists I want but I need to extend that function to row 150. I tried to paste: =Indirect($B$25), =Indirect($B$26), =Indirect($B$27), =Indirect($B$28)....=Indirect($B$150) into the Item column but it did not work.
Also, I need to input a number into the Quantity cell and then have the Item cost multiplied by that number and shown in the Item Total $ cell. After all of the items are chosen, the totals from the Item Total $ cells need to be represented as a sum in the Total Job Cost cell.
Solved by M. J. in 28 mins
I need data validation to work down multiple rows and I only know how to do it one at a time. On the sheet you will see: Space & Item.
I have figured out creating dropdowns in excel as I want but I need to extend the Space and Item drop down menus to row 150.
Solved by S. Y. in 25 mins
I am trying to use data validation tables for certain entities and their related bank accounts. The form I need to enter the data into does not have vertical column headings - but it has the field name on the side instead. Also - my information has a lot of spaces/long names. Is there a way to use dependent excel data validation list from table so that if I choose one entity, it will only let me choose from its related bank accounts instead of all possible bank accounts?
Solved by G. H. in 19 mins