jonas sværke

Hi all, I currently have this setup: I would like to have column E automatically paste column D, but as values. Right now column D is filled with the formula (=A+B). I would like to have this pasted as values into column E, but done so on an automatic basis. The easiest solution I see would...

Hi all! I am currently comparing values in two sheets to each other to see if they are similar or dissimilar. I have this setup at the moment: My formula is: =IF(COUNTIFS('[CONFIDENTIAL - NUMBER.xlsx]Sheet1'!$T$2:$T$1712;E2;'[CONFIDENTIAL - NUMBER.xlsx]Sheet1'!$R$2:$R$1712;A2)=1;"yes";"no")...

Hi all, I currently have this graph: I don't really care about the light and dark orange columns, but I need them to stay nonetheless. However, the grey chart rises from a value of about 9300 to 10500 doing this period, which is not that noticeable in this chart to be honest. I would like...

Hi all, I currently have this setup: My formulas in columns J-M look at their respective counterparts in columns D-G and once all four numbers have been entered in columns D, E, F and G, the cells in columns J-M will highlight which one has the lowest value. However, I would like to...

Hi all, I currently have this graph here: I would like to color the area inbetween the yellow and the red line with an orange color. I would like to know: 1) is this possible, and if so, how? 2) if it is possible, is it also possible to make it do this coloring without pasting the orange...

Hi all, I currently have a large data set, it looks like this: I want to vlookup my data from column A-C into column J-L. However, as the names reappear and sometimes even share the same date (example in A4:B5) a vlookup won't be feasible. The dates are correct in my other table, as well as...

Hi all, I have this file that was converted from PDF to Excel. I would really like to filter everything in column A by date However, when I do it looks like this: It filters down until row 687 The row looks like this: I have no idea why it stops? It used to stop at points like these...

Hi all, I am very rusty in Vlookup (embarassing!) and I am currently looking at this data: I would like to create a formula that checks the same date in column A, as checked in column F and then tells me whether or not the value for this date is also present in my data set in columns F-G. I...

Hi all, I currently have a data set that looks like this: The issue for me is that it is currently stated in a format of "Month-Date-Year". I would like to replace this with a format of "Date-Month-Year". Does anybody have a nice solution to this, for example a formula as illustrated in my...

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 have the current VBA code: Option Explicit Private Const FilePath As String = "S:\File Path anonymous\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim ws As Worksheet Dim col As New Collection, itm As Variant Dim...

Hi all, I currently have this code, which saves my sheet (entitled "Sheet3") as a PDF: Option Explicit Sub SaveFileWithMacro() Dim Path As String Dim fn As String Path = "S:\Path\PDF files\" fn = Range("A63") ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Path & fn & ".pdf" End...

Hi all, This may seem super simple and silly to ask, but I have currently made this setup: I have hidden EVERYTHING except for rows and column 1-7. However, I would like to unhide row 8-10 now, but I have no idea how? When I click on "7", which is the closest row I can currently touch, and...

Hi all, I have this formula: It pulls in data from here: However, despite this column being completely empty, it returns the value 0, rather than a blank cell as I have commanded it to. I have checked the cells in column H and there are nothing there, not even a space, so i do not...

Hi all, I have this very complex formula: It returns a date value from a different sheet. However, it is returned in a number format, rather than a date format. Any idea how to fix this? I believe that I can use the TEXT() formula, but I cannot figure out how :( If anybody can help me...

Hi all, I currently have this formula: The formula is supposed to look at the values for the company (column B) and the topic (column F) and then based on the value in column F, it will look at the sheet with the same name and find the values here: I likewise have a sheet with the same name...

Hi all, I have this formula: Essentially, when I fill in ANY data or make ANY changes to cell D2, i want the VBA to automatically update the current date/time in cell B1, so I can see the last time I made any update to cell D2. I can do xOffsetColumn = -2 But this will show the date in...

Hi all, I currently have a list that looks like this (albeit much much much larger in reality): I would like to create a slicer for column D (Height (CM)). However, my table is not a pivot table. Does anybody know how to do this? I read online that I have to go into the design tab and do it...

Hi all, I have an overview like this: I am looking at four quarters for a year. I have a filter as well. I want to specifically hide the first three quarters somehow. However, please note that: 1) I cannot use a filter, because I often use a macro that wont work if a filter is on, and 2) I...

Hi all, I have this overview at the moment: If I manually choose to save my file as a PDF, it works fine and I get just 1 page with the overview above. However, I have the following VBA code to save my file as a PDF: Option Explicit Sub SaveFileWithMacro() Dim Path As String Dim fn As...