sonaj jværke

Hi all, I currently have a data set that looks like this: I would like to transpose my information down under columns H-L so that for ALL cells in A that contains "George", their respective cells in columns B-F will be transposed under column H. Likewise the same for all cells that contain...

Hi all, I currently have a very messy sheet that looks like this: Essentially, row 1 is the heading, row 2-3 is the results that I want to produce through a text to columns, and rows 24-45 are the data that I currently have. The issue is that my cells have become messed up, so for every...

Hi all, I currently have a macro that saves my sheet as a PDF, however when I try to do this, it brings me this error: If I debug it highlights this in my VBA code: The code is this: Option Explicit Sub SaveFileWithMacro() Dim Path As String Dim fn As String Path = "R:Path\PDF files\"...

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