data validation list

  1. K

    AutoComplete From a List

    I have a list on a separate sheet that I am wanting one particular cell to autocomplete from. I have searched for quite some time on a resolution to the issue. I have even placed the list above the cells I am working with, and then hiding them, but after I am finished with my current task I...
  2. L

    Data validation list and Vlookup in VBA, to input, on cell change, if/vlookup formula referencing cell that was changed

    Dear Excel Guru’s I’m struggling with one of my last tryouts in Excel Macros. I would like to have in my sheet combination of Data validation list & Vlookup. But I want to have it in Macro, so user won’t be able to see formulas, delete, edit etc.. I succeed with stand-alone Macro (what was...
  3. M

    Data validation list / sublist

    Hi, is there a way for haveing a dependant list but in the same cell. For example here Excel Dependent Drop-down Lists - Easy Excel Tutorial The list are it two different cell. What i need is that for example in the same cell i can see a multi level list. I hope i was clear in explaining...
  4. B

    Drop Down with Autocomplete help

    Hi all - new to the message board, need a little help. I have some experience with VBA, but I am far from a master. I essentially have a sheet where for each line (maybe 100 lines to a sheet) a reviewer selects a value from a very long drop down list to provide the status for the individual...
  5. J

    changing the color of a cell for invalid values while copy/paste on a cell with "Data Validation"

    Hello I created a list data validation to a range of cells using =INDIRECT(SUBSTITUTE($D3," ","_")), and it works great, I do understand that there is a limitation that data validation only works with user enter values, however I need to populate the range with a Copy/Paste, so what I need, if...
  6. E

    Data Validation List to skip every other column

    I can't seem to get a good formula to return a drop down list using Data Validation for every other cell in a row. I need a dropdown list that produces the values from D9:AR9, the list would only include D9,F9,H9,L9...AN9,AP9 and AR9. I can produce a formula that I can drag across columns to...
  7. C

    VLOOKUP, DATE, TODAY, and IF - Help Needed

    I have a column with all the Sundays for the year 2014. However, in another column, I need to eliminate the Sundays that have already gone past the TODAY date so I can use this to create a list using Data Validation. I have tried all formulas that I can think of based on this logic but I am...
  8. G

    Restrict Data Validation

    Hello, I am having an issue restricting a cell to only what is in the drop down. I have a cell that is data validated as a list to be passed this: =IF(B4="Lease",$O$3:$O$6,INDIRECT(VLOOKUP($P$21,$O$2:$S$17,5))) the indirect passes a range for example "O2:O11" which would fill the drop down...
  9. D

    Populating a list by selecting data in another list.

    I figure this is an unusual question, and I'm just hoping their is an answer out there. I am currently accessing data off a SharePoint server where the data will self populate into my excel document. This works fine. I have a drop-down list created through data validation. The drop-down list...
  10. I

    Ignore Duplicate Entries on (dynamic) Data Validation List

    First of all I would like to thank you in advance for taking the time to read my question, I have looked everywhere for a solution with no avail, without further ado, here is the problem: Suppose we have three columns as below: (I am using Excel 2010) ID Sys Code 1 Roma A4 2 Roma...
  11. J

    Conditional Formating from a Data Validation List

    Scenario: Sheet 1;Column C and Column D: I have user typed "Customer Names" in Column C. I have a drop down list in Column D, which allows user to designate the customers as a "Partner" or a "Non-Partner" I have a color coded conditional formatting on Sheet 1 working properly based on...
  12. D

    Copying Cells with Data Validation

    Is there a way to copy cells with dropdown lists in one workbook to another? I can copy this to another worksheet within the same workbook but it doesn't work if I copy to another workbook.
  13. M

    Hide/Unhide Columns Based on Date Range in Data Validation List Selection

    Hi, I'm trying to work on a macro to hide and unhide columns based on the date that was selected on a data validation list. My date columns are from "F" to "GG", and my data validation list is on "B9". I researched on some macros but to no avail. Here's what my current macro looks like...
  14. D

    Data validation: List of values in an array excluding values that equal ""

    Hi, I have an automatically updated list going down a column. (100 rows in the column have a formula and it is basically saying it equals the next figure in the list that has been selected until there are no others and it then =""). =IF(ROWS($L$3:L3)<=(COUNTIF('Purchases...
  15. P

    how to combine data validation list with pop-up image appear(image into comment box) function?

    hi guys, how to combining/joining data validation list with pop-up image appear(image into comment box) function?is it possible?
  16. B

    Combine Cell Contents with a Named Range

    Hi, there. I have a cell with a drop-down menu where the user can select "Plant A" or "Plant B". I have a cell below that with a sales number, which comes from a different tab where the sales number is input and has a named range. For example, the input tab has a named range called "Plant A...
  17. C

    Changing the font size of a data validation list

    Hi guys, Win 7 64bit Excel 2010 I have grapppled with with one for a while now and through direction ended up finding a nifty piece of code that overlays a combobox onto your validation list when double clicked; very useful. When I went to integrate this code into a second worksheet I found...
  18. Y

    Data validation list or something else?

    I have a worksheet that holds records for clients, stored with their surname. On another sheet a new record can be entered, with their surname being entered in cell K4. I'd like to have users be able to either type a new surname, or select one previously used from the stored records. Is data...
  19. F

    Data Validation

    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?
  20. M

    Combine List with a Vlookup

    Hi! Is it possible to use a vlookup formula and, if no value is located, select from a drop-down list within the same cell? Not sure if this is possible. Hope this makes. Let me know if you need any other info. Cheers!! M

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top