single

Hello all, I have what is hopefully a simple solution to solve. I have a sheet for staff to complete entries into columns A-G a single row at a time. In column H I have a check to make sure all entries are made and return a 1 if anything is missing. In column I u have the users email address. I...

Hi Guys I need to ensure that if a combobox has a specific entry, a further txtbox also needs an entry The code I have used for single entries is working fine but I can't get the dual entry to work The codes I use are as below: For the single entry If cmbStatus.Value = "" Then MsgBox...

I have this which I am using to track changes to a range; Dim xrng As Range Set xrng = Range("A2:N16") If Not Application.Intersect(xrng, Range(Target.Address)) _ Is Nothing Then Set ws = Sheet1 iRow = ws.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row...

Hello, Im relatively new to VBA codes. I usually manage to work these things out myself, but cant seem to crack it this time...! Im using a VBA code to autosize row height for merged cells. The code (below) works when I run it, but otherwise doesnt seem to update. Private Sub...

Complicated VBA with 2 Conditions, 1 = Row target Sum, 2= Single number in the row</SPAN></SPAN> Hello,</SPAN></SPAN> I am looking some specific solution I will try my best to explain here, if it is not clear. Please ask any question I will try to make it clearer</SPAN></SPAN> There is...

Hi, I need to apply two data validations in a single cell. One is the name and other is a text 1) =validation_customers (This one is a named range) 2) ALL (This one is a simple Text) I would like to know how to apply these two in a single cell. Any help would be appreciated. Regards, Humayun

https://paste.pics/b10ffadd0ed8462a39d6bc8608bf6258

Hi guys... Need help, please. I was trying to create a single chart in which one set of data (premium) will show in stacked chart and another set of data (policy count) will show as a line chart. All of them will be in a single graph. I have the data here in google drive...

Existing Macro:- I have an existing macro with a send Email button on clicking it will send separate mails with single attachment to all the owner.present in the excel sheet. Requirement:- while clicking on send mail button it should first pick an owner i.e. mail recipient from coloum D of...

Hi, Each month I download a csv overview of creditcard expenditures and save it as an xls file. On each line I add the word "link" in column K. I then add a link to the receipt. I am on a mac. [The linked receipts are stored in a Devonthink database, the links open the relevant document...

what i have: ActiveCell.FormulaR1C1 = "=IF(ISNUMBER(MATCH(R[0]C[-1],'Hierarchy'!B:B,0))," & Chr(34) & "Exist" & Chr(34) & "," & Chr(34) & "No" & Chr(34) & ")" What i want: =IF(ISNUMBER(MATCH(G2,'Hierarchy'!B:B,0)),"Exist","No") What i'm getting...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Data in columns C:P, need to count "0" and "1" in a single cell separated by vertical bar in the column R </SPAN></SPAN> Example data</SPAN></SPAN> Book1ABCDEFGHIJKLMNOPQRST12345P1P2P3P4P5P6P7P8P9P10P11P12P13P14EMCount 0 And...

Hi All, This may already be answered on here, but couldn't find exactly what I was looking for... I want to take this, data pasted into Excel as rows, with varying lengths of columns (can assume I paste into Column B): <tbody> a b c d e f g h i j k l m n o p q r s t...

Hi, I would like to be able to pick a folder and then the macro/script goes through the main folder + subfolders and then also e-mails within to check their category and then post a result on how many mails were put on the different categories. I have found two different scripts that each...

I have two words in one cell in the data table, for example "apple pear" which have been concatenated from previous cells (in some cases I might have up to 6 entries) but in the pivot it shows as 1 entry. I need apple & pear to be 2 single entries in the pivot table. What can I put in the...

I have and excel file with about 200 rows. Consecutive columns have cells with last name, first name but in between those pairs of couple there are single names. I want to sort the file in alphabetical order keeping all the couples together and listing the single names at the end and of course...

Hi folks, new member here from the UK. I've inherited a list which includes thousands of dates of birth However, the dates have been input in individual (Numeric) columns for each of Day, Month & Year (UK date style). I'd like to convert them into a single date field but my brain can't think...

I'm trying to adapt a function that currently uses Range.Characters and replace it with something that can be done in array. I had some ideas but it doesn't appear they were feasible. I did have one thought that I think is doable but I need some direction. I pose my myriad of questions here...

Good day experts, I am wondering if I can sum up non empty cells but it should add only single value for every group of inputs: <tbody> A B C D E F G H I J Sum 5 5 2 2 2 2 2 2 9 1 1 1 1 1 1 2 4 </tbody> Appreciate your help on this query. Thank you so much.

Hi Thanks beforehand. My problem is that im trying to create a pdf from an excel sheet but I need to create a single pdf with a single page with the same sheet, cutting ranges from the excel and and pasting them on top of another... they are different tables.