validate data

  1. N

    Formula for same code

    For the same code in sheet ‘A’ and Sheet ‘B’ i need the Length value be a major than 0 and equal to value of cell in sheet ‘A’ for example In sheet ‘A’, put Code “eac” and length = 125. In sheet ‘B’, put this: <tbody> Code Length eac 100 ok eac 25 ok eac 25 ok </tbody> This...
  2. J

    if value is not in range

    <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier...
  3. Z

    Two validations in one Cell

    Hi. I'm a new user and i'm finding a solution for this case: I need that in a one cell the user input only can write a string specifically of 7 or 10 characters, the values 1 to 6 and 8, 9, or greater than 10 are not valid, I tried to solve this with validation but i can't, i hope anyone can...
  4. P

    VBA to Validate Data

    Hello, I am a true beginner to VBA and would like some help in creating a macro that is triggered when the user goes to save the document. The document contains a check box and, if checked, cell B28 will show TRUE. If the check box is checked, the user is expected to enter additional...
  5. K

    VBA Transpose from column to Row

    Hi all, Thank you in advance for helping. I am very new for VBA and have some data would like to transpose from column to row where it is dynamic, see below, please - <colgroup><col style="width:58pt" span="2" width="77"> </colgroup><tbody> Item - Value 1 D 2 A...

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