check

  1. C

    Use formulae to check that 2 variables on sheet A appear in the same row on sheet B

    Hi I am trying to use formulae to check that the order number (sheet A, cell B4) and week due (sheet A, cell Q4 as YYWW) values are found in the same row of sheet B. The order numbers are stored in column E of sheet B, the due date is stored in column O of sheet B as WW. Note the order number...
  2. L

    Conditional Format formula

    I would appreciate any help with the following. A1 contains the name of a city say Reading. F1 contains a mnemonic for that city which in this case is logically RE. However the RE is not always the only letters in the cell. So what I need is a CF formula that will check if the first 2...
  3. V

    Modify / Edit in Formula - Match and Result

    Hi All, We have the following sheet Excel 2010 32 bit ABCDEFGHIJKLMNOP 1DanialChrixRockyRickylogghunDanialChrixRockyRickylogghun 2RonaldoPamelaDonaldmessysanjusafiRonaldoPamelaDonaldmessysanjusafi 3shikarghurandyjohnvijjurodishikarghurandyjohnvijjurodi...
  4. B

    UserForm to replace working code

    I have a bid form that works, but the code is cumbersome. I have a column of check boxes called "include", a column off the same called "Exclude", a column of items to be included or excluded, and column of notes for the item. After selecting the check boxes i have code that adds the selected...
  5. C

    Check Digit

    Trying to do a 10 digit mod 10 check digit with a weight of 7,5,3,2...can you assist me. Thanks.
  6. gheyman

    Covert a Table to range

    I have code that takes a table and converts it to a range ActiveSheet.ListObjects(1).Unlist But now I need it to check and see if there is actually a table to convert before it runs the code How do I check to see if there is a table first?
  7. S

    Getting messy data into one line

    A big part of my job is getting spreadsheet data from different clients and putting the information into our database. Most of our 200+ companies send reasonable spreadsheets I can manipulate pretty fast, but one insists on sending what I think is a scan of their paychecks, converted into...
  8. F

    Deleting empty rows code doesn't respond

    Ok. Desperation is setting in!!! I have two worksheets, "Clash Check" and "Clash Report". The sheet "Clash Check" gathers data which ends up as a list of names etc across 3 columns with lots of blank rows in it. I have a code which can run through the list and take the blank rows out based on...
  9. A

    loop to check if visible

    I have a userform that has multiple labels. 10 labels are named with the leading text lblM_ (see below). I want to check if any of these labels are visible. I kindly ask for assistance with a vba code to check if any of these labels are visible lblM_tbxSch800 lblM_tbxSch900 lblM_tbxSch1000...
  10. kelly mort

    VBA code to check if any of a range of controls are blank

    Hi, I have done some sniffing around to see if I can find solution to my problem. I came close but needed a hand to finish it up for me. Dim allEmpty As Boolean allEmpty =True For Each crtl In Me.Controls If crtl.Name Like "txtM*" Then If Trim(crtl.Value) <> "" Then...
  11. K

    Spell Check in UserForm

    Hi everyone, Is there a way that I can do a spell check in a UserForm, before the information is sent to the worksheet. I know I can add code to do a spell check after the information is added to the worksheet, but in my case, some of the text will be sent to two different worksheets. Therefore...
  12. D

    Fuzzy Lookup Meets Find and Replace

    So first things first, my title might be inaccurate but I'm not sure of the terminology. I have a long list within a single column of various length text. Most of these text strings will contain, in part, 1 of about 30 known phrases. In the column next to the original text I'd like to place the...
  13. Mazbuka

    opying into cells if particular criteria is met

    I have an excel journal template that I want completed from a cashbook type source...I'll show a simple example: Say this is my cashbook <colgroup><col span="4"><col><col span="3"><col></colgroup><tbody> A B C D 1 DATE DETAIL AMOUNT CASH/CHECK 2 17-10-19 John 1000...
  14. T

    Linking a check box to a column in a table

    I have a check box on a worksheet that I would link to a field in a column. The issue that it is a table and I would like to be able to have the linked field always be the new line in the table. is this possible? Thank you.
  15. muhammad susanto

    Check If Cell Not Empy in Multiple Rows

    hi all.. how to check if cell not empty, say ok otherwise no <tbody> data1 data2 data3 data4 target 34 8745 898 ok no 56 ok </tbody> any help, thanks in advance. .sst
  16. A

    Need help! Lookup function

    Hello! I need help regarding my file. I am working on my cheque warehousing file. I have a sheet that contains all of my warehoused cheques.I need to create a file wherein it can give me same dated cheques in one sheet. Can you please give me tips on how to do it. I used vlookup but its tedious...
  17. N

    Check for duplicates

    Hello, I have a userform with 8 textboxes (txt_Name1, txt_Name2...txt_Name8) I'm trying to add a piece of code to check the textboxes above if any name is duplicate, I tried the following code but didn't work Can you please help me? Code: Private Sub cmd_Add_Clich() Dim i As Long For i = 1...
  18. F

    Reference cells from source worksheet to destination if condition are met

    Good day, I have the following sample data(excerpt from a large dataset) below and name it as Sheet1: <tbody> </tbody> <tbody> NO DATE BRAND ORDER MODEL QTY 1 21/8/2019 <tbody> CATHAY </tbody> <tbody> C123456 </tbody> <tbody> AIRBUS </tbody> 200 2 21/8/2019 SILKAIR...
  19. J

    Conditional formatting highlight

    Hi, My formula seem to be wrong. Can any one please help me check the formula. Appreciate in advance. Thank you. https://drive.google.com/drive/folders/1GONwJfx01v_XZeHrg3burkBavuF3ffIJ?usp=sharing
  20. R

    Check to see if sheet exists before Power Query consolidation

    Hi there I have about 40 files that I need to append through Power Query. In my model the user selects a month and then the sheet with that month name is consolidated. It works great until someone uploads a file that doesn't have any sheets with that month name. How can I get power query to...

Some videos you may like

This Week's Hot Topics

Top