sanoj ekrævs

Hi all! I currently have this setup (albeit with more columns in reality): I would like to sort it by dates first, and then by the number after. However, I want this done, so it respects the date assortment before the number assortment, so it wouldnt for example put: 1 - February: 1 Before...

Hi all, I currently have this setup: Formula in full: INDEX('Q4'!$V$3:$V$73,MATCH(1, ('Q4'!$B$3:$B$73=List!$D651)*('Q4'!$A$3:$A$73=List!$N651),0)) My sheet used to be simply called "Sheet1". However, I have renamed it "Q4" now. I want my formula to pull in data based on the value in column...

Hi all! I have this setup (albeit much larger in reality): Every statement has a sentence with "XYZ employees". Is there a formula that can detect when a sentence says a number, followed by the string value "employees", and then return the value of the number? So that formula can fill out...

Hi all, I have the following formula: The formula checks if the value in column D is located anywhere in sheet 2's values in the array B1:D133. However, when I pull the formula down, it also checks blank cells. Is there any way to edit this formula, so when it checks a blank cell (for...

Hi all, I have this formula I found online: I have now set the formula to test if my value "test" in cell B2 is located anywhere at all in within the value set B1:D133 in sheet 2. I literally have the value "test" in cell B2, but it does not work: It should return the value "1" if the...

Hi all, I currently have this VBA code: Option Explicit Private Const FilePath As String = "S:\COMPANY\FOLDER OF COMPANY\FOLDER 15\TEST FOLDER\Attachments\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim ws As Worksheet Dim col As...

Hi all, I currently have this setup: My VBA code is this ( credits to @RoryA :) ) Option Explicit Private Const FilePath As String = "\\UBSPROD.MSAD.UBS.NET\userdata\t684895\home\Documents\faq folder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i...

Hi all, I have this amazing email macro that @RoryA helped me build (big credits!). He created a nice loop for me that runs all subjects in an email meaning I can email as many email addresses as I want at a time. However, when I run it now, it converts my text into numbers for some reason...

Hi all, I have a sheet with an email in cell A64. I am trying to create a macro that will send an email to this email, but when I click my macro I get this error: and debug highlights this: Did I not do it correctly? What do I need to fix? Thank you all! BR. Jyggalag