data validation (list)

Hi folks, I'm running Excel 2000 with a legacy spreadsheet which has a single worksheet. Each row contains the details of a given task performed by a particular farm vehicle. The row includes the day. month and year that each job was performed (in separate columns), along with a brief job...

Hello, I am a new member and a relatively new Excel user so I apologize if this question has already been asked and answered, I thank everybody who will take the time to read and respond and I welcome any advice or solution for this problem. Ok, so I have added pictures to my workbook using the...

Excel VBA code is required to Select the Name in the Data Validation list on a cell value after the same name could be run in the sub macro. E.g. Data Validation List assigned in "Sheet3" cell text value "B2". if I select the "AA" and then Call to "AA" Sub Marco run. I got error the code line...

Hello! Is it possible to have a formula or code that allows for selecting multiple selections from a drop down list that can appear in one cell? Potentially separated by commas? I've seen some folks talk about a VBA code, or a potential list box, but I am not sure where to begin. Attached is my...

I currently have the issue I cannot backspace on the first value in a cell without throwing all other values in the cell off. This seems to happen when the cell only has 2 values - a Stop Alert I’ve called ‘User Error’ (using Data Validation) is not thrown either. I’m trying to standardize...

Hi, I was able to create a a data validation list by using UNIQUE, however, my rows may change whenever I update the template. Can anyone advise how can I change my current formula to consider the rows changes...

I have tried all that I could find on this site. What I am trying to do is Sumif the colums: Column E,Owner, uses dropdown Coumn F is the the amount paid: =IF(E20="Ian","$.50","") Column G,Payment,I want to total all of Column F: I have: =sumproduct(sumif($E2:$E49,"-ian",$F2:$F49)) also have...

Hi All, I struggled a bit with the title - so I'll try to explain more clearly. I have created a Table in Excel, which I intend to share with a selection of users to populate. This will result in a indeterminate number of rows being populated. Each column in my Table (10 columns in total)...

I have received a new spreadsheet with the annual budget for the 22-23 fiscal year. I also have 5 clients, each with an allocated percentage or breakdown of how much the overall budget is to be applied. Example: client 1 will receive 33% of the overall budget. Is there a way I can have a...

Hello everyone, I have the following code which that does not allow the user to paste values in a Data Validation List Column. My problem is that I have columns (without data validation) that have to stay protected, columns With Data Validation List have no locked option from format cell, but...

Hi, I'm trying to create a system that associates a data-validation system to a set of columns. The data validation should be based on different lists of values, depending on the specific column name. Each list of values is contained within different sheets of the workbook. The workbook is...

Hi I have 4 lists and I would like to use data validation selecting from these 4 lists to give me one of 4 possible text outputs as below What is the best way to do this please - do i need to list out all the possible combinations and my desired outcome for each somewhere on the sheet or is...

Hi everyone, I have three columns A, B, and C and I want to filter the rows that pertain to one of the drop-down list selections that I created, what would be the formula for this? For example, I have listed the first, second and third job preferences of a number of people. I would like to...

I'm developing a workbook for Risk Analysis. Currently we have a single list/array with several thousand lines. We want to make it more managable, by splitting it according the different departments. But the Risk Theme and specific Risks are identical for all departments. I've created a...

Hi, I am trying to create a multiple dependent dynamic data validation in multiple rows. I have tried doing it through name table / Indirect Function and it's working only in the first row. In the Second Row (Column 1) when I am selecting different data, in that case in Column 2 its still...

Hi, there are many rows in my worksheet. For all cells in one column of this worksheet, I want that user can enter multiple options from a list. How can that be done? For e.g. I have 10 rows, and each cell from A1 to A10 represents a person. Then, there is a list of items that a person can...

I am trying to set up data validation for a report, but two columns aren't flagging blank cells they it should. The "Blank" list is the title and one blank cell below it. The AcceptReason has four selections below the title, and the RejectReason has ten. Column I has data validation for...

Hi All, I have tried option to use validations list using Indirect/Vlookup, and its seems no results in Vlookup using. Source - Entry Table UniqueErrorField ErrorField ErrorsNoted Age Age TOP BOX - Wrong Age APS Date Range APS Date Range TOP BOX - Wrong Entry BP History APS Date Range...

Hi everyone So I posted in here a few weeks ago and someone wrote me an excellent VBA which cuts and pastes rows to different sheets depending on what's written in column F of my workbook. The code is as follows: Sub sort_my_data() 'VBA written by SQUIDD from MrExcel.com...

Hi all, I'm simply looking for some clarity on how the Ignore Blanks option works within Data Validation. It was always my belief that unticking this would prevent the user from leaving the relevant cell blank. For instance, if the user deleted the contents of a validated cell but did not...