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...
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...
We have the following sheet
Excel 2010 32 bit
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...
I have code that takes a table and converts it to a range
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?
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...
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...
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
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
For Each crtl In Me.Controls
If crtl.Name Like "txtM*" Then
If Trim(crtl.Value) <> "" Then...
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...
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>
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?
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...
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?
Private Sub cmd_Add_Clich()
Dim i As Long
For i = 1...
I have the following sample data(excerpt from a large dataset) below and name it as Sheet1:
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...