datavalidation

  1. J

    Add data with blank cells to new table + Data validation without blanks

    Hi guys! I ran into a problem which I can't seem to solve. I am on Excel for Mac 2019 Problem: 1. Table 1 is new data. This data contains blank cells in between. I want it to add to table 2, without the blanks. Not directly under it but under table 2 [cell E26] 2. The new table still have...
  2. RJSIGKITS

    VBA Message box to show if user tries to enter info into a cell when another cell is empty

    Hi. Could someone please help me with this, as I can't get it to work right. I need to add a message box VBA to my worksheet which forces a user to enter other data before they can enter data into a specific cell, as follows: User needs to add data on the worksheet, which fills Cell H1, in...
  3. A

    Can 1st Column Data validation (list) control 2nd Column vlaue list?

    Hi there, I need help with the data validation set up. I have 3 tables. Table1 name=activities (containing 2 data points, being used as a dropdown list using datavalidation on col D) Table2 name=SubActivities of activity1 (containing 2 data points, being used as a dropdown list with...
  4. S

    Show/Hide Several Sheets based on Data Validation

    Greetings, new user who is not a VBA pro and would appreciate help. I'm also working on a navigate sheets ribbon, which I can post/reciprocate when I finish. I'm working on a workbook, where the user will select from a list (datavalidation) with a range name "AssetType", and based on their...
  5. M

    Identifying unique data based on 2 criteria using the .find function

    Hi all, I am working on a macro that will take data from one workbook and move it into another scheduling workbook. When i transfer the data over to the scheduling workbook I need to check to make sure the data i am transferring is unique based upon two criteria, Job# and heat#. If the new data...
  6. K

    Not possible to extend series on data validation cells in protected sheet.

    I would like to protect shapes so I use the argument DrawingObjects:=True. However, with this argument set, it's not possible anymore to extend series on cells with a data validation list. In example, click on cell A1 and autofill the data to cell A10 won't work. The hand mousepointer appears...
  7. S

    Help with Multiple levels of Data Validation

    Hello, I'm looking to put a drop down list in a column E2:E32 which gives the option to select "White", "Gray", or "Black". I also want a countif to trigger a warning if a duplicate is entered in column E withn columns B through D of the same row. Is it possible to add two levels of data...
  8. S

    Data Type Error

    I am currently trying to use an OFFSET formula to declare a range for use in a Drop Down List. The formula works fine in a cell or range of cells however, when I try to use it in the Data Validation source it throws an error claiming something is wrong in the formula. After some investigation I...
  9. N

    Dependent cell data validation

    Hi everyone (I'm new)! I have an issue I cannot seem to figure out. -So I have 2 cells, B1 and B2 say. -If B2 is 0 I need B1 to stay 0 as well, but I need an error message to pop up if someone changes it. -If B2 is >0 B1 can be whatever manually entered number you want. So my steps to...
  10. T

    Unable to clear the contents of Datavalidation in excel using VBA

    Hi, I have a VBA function that will bind an array to excel range and in turn use that range to specify a data validation list for the selected range. I want to remove the datavalidation if the array that i'am passing is empty but this doesnt happen, i can still see the dropdown of previous...
  11. K

    Listbox MultiSelect

    I'm have a project at work where I want to make multiselections of a list. These selections will again appear in the next column (or next row). I've used datavalidation before, but I can then just make one selection, but I want to be able to make more than one selection from the list. Maybe me...
  12. N

    Error message when cell left blank

    Hi Community, I'm producing a template for auditing purposes and is going to be provided to outsourced companies to complete the task. I'd like to know if there is a data validation or macro that wont allow the auditor to leave a cell blank when he clicks on it because in the past we have had...
  13. T

    BeforeDoubleClick on Protected Sheet with DataValidation

    I have a protected sheet where users can make choices (by DataValidation) to certain cells. I want to use the "BeforeDoubleClick" event to let the users switch between the options. So if a cell holds "Option A" and "Option B", then doubleclicking would switch from "Option A" to "Option B" and...
  14. Jaafar Tribak

    Data Validation InCellDropDown

    Hi all. I need to have the dropdown of a cell with a data validation always on display without needing to have the cell selected and clicking on the arrow or pressing Alt + Arrow Key ? Any ideas ? Regards.
  15. D

    data validation, vlookup or what??

    I have a cost estimation spreadsheet. I have cell A6 pull data validation name list of hardware from another sheet. Then I have cell B6 pull data vlaidation name list of software from another sheet. Then they calculate into another cell and it works wonderful. What I am trying to do now is...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    • Started by Unexpc
    • Replies: 39
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
  • IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
    • Started by IDRIS86
    • Replies: 25
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    • Started by DEllis
    • Replies: 21
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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
Top