check

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

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

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.

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

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

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

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

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

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

Hi Everyone I need a macro to mack sure people are filling in both columns what I need is if any cells in Range AH52:AH252 have data in them then check that the same row for column AG has data, if not message box "please fill in all departments before proceeding!" please help if you can Tony

Hi! Well i have a question for check keypress for multiple textbox with public sub. Heres example how i have done it now for each textbox. Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) KeyAscii = KeyAscii * -CLng(Chr(KeyAscii) Like "[0-9]") End Sub So i would like...

I have a table as follows Row 1 03-Mar-20... 03-Mar-21... 03-Mar-22... 03-Mar-23... 03-Mar-24... Row 2 02-Mar-21... 02-Mar-22... 02-Mar-23... 02-Mar-24... 02-Mar-25... Row 3 T1... T2... T3... T4... T5... .. up to...

Hi all I have workbook with data in sheet(result) sheet(result).range(F1) have value like: yyyymm=> 201909, 201908 .... Now I want macro to check that: 1. Get 02 character from right(range(F1)) = b 2. If b <> 12 then check each cell(1,j).value from range(G1, last column) - If cell(1,j).value =...

If I hide rows on my spreadsheet which have check boxes on them, the check boxes do not disappear, they appear to stack up behind each other Is there a way to also hide these check boxes? I am using VBA to hide the rows so a VBA bit of code to hide the check boxes would be perfect! TIA

Hi, honestly i have no idea wich formula to use in excel2010 - to solve this problem. I need to check if deposit 1 is equal with deposit 2. it is easy when there is only one value in both columns (row 1) simple deposit 1 =deposit 2 to give me true or fale value in the check column. However the...

Hey all, I use this small code to check if the date entered is in the future or not. If it is the user gets a messagebox and the cell should empty. Private Sub txtStDate_Change()If CDate(txtStDate.Value) > Date Then MsgBox "The date of observation is in the future." & vbCrLf & "This is not...

I've inserted a Form control check box in sheet "Start sheet". This check box is made up of 9 rows & 2 columns ( cells K26:L34) with the names of continents [column K] so that a user can select one or more [tick boxes in column L]. I would like to use vba to step through these check boxes and...

I'm trying to figure out the best approach for this task; - user selects yes or no from a dropdown (or a check box would be nicer visually) - if user selects no, nothing happens - if user selects yes, a further 4 "questions" need answering, the possible answers should be from dropdowns not...

I had data from A to T I want to check the entire column of D, if there is a empty cell. Marco will aborted. MsgBox "Pls ensure Col D is not empty"

Good Afternoon, I quite new to excel VBA so sorry if I've not posted correctly. I was wondering if there I away to run a Macro that will check a MOT date and return the date the MOT is due. I.e if I have got a registration number in cell A1 and another registration in A2 and so on, I won't...