data validation 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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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.

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...

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...

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

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...

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...

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...

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! 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