fast

Hi all, I have an open workbook with three sheets called "1", "2", and "3". I want to hide these sheets and make it so that you cannot open or view them without a specific password. Right now, I can protect these sheets. However, protecting them means that you can still click on the sheets...

Hi all, I currently have a very large data sheet that looks like this: In this example, I've just put in a format of: Date,Name,Gender Please note that some of the cells however might only have Date,Gender or Name,Gender or Date,Gender etc. My ideal format would be: Date,Name,Gender...

Hi all, I am currently working with a data set that looks like this: I would like a formula that takes all the values in column A, and if they begin with a comma (","), it should remove this So the result should be like this: Does anybody have a formula for this? It would be greatly...

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 a macro that converts my excel sheet into a PDF and saves it in a designated folder. However, I only want it to save the first sheet as a PDF, and ignore my other sheets, which it will not do at the moment. My code looks as follows: Option Explicit Sub...

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 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, 2 questions: 1) I have the following setup: I add new files quarterly to my excel file, so Q1 2021, Q2 2021, Q3 2021, Q4 2021, Q1 2022, Q2 2022 etc. Right now I only have one for each year, but I plan to add many more going forward for 2022- Does anybody have a way in which I can...

Hi all, I currently have the following setup: I have some numbers in column C and D, and I use a simple sum() formula in column B. However, I also want to be able to click on the cells in column B and see the value in the formula bar. But I want to keep the formulas in the meantime. What I...

Hi all! I currently have this setup, please note that I have hidden all the nonrelevant columns however: The formula I use is this (thank you @RoryA !) =IFERROR(INDEX(INDIRECT("'"&H504&"'!$U$3:$U$73"),MATCH(1...

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 code attached to a macro: Option Explicit Private Const FilePath As String = "R:\LXI_DLL\ZGJ_COMMON\FLD COMP FOLDER\12-FOLDER\TOPIC 2\ATTACHMENTS\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim ws As Worksheet...

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 a data overview that draws data through power query from a folder in my windows computer: However, I plan to update this folder rapidly every week and I was wondering if it would be possible to create two macros attached to VBA codes, where they do the following: 1)...

Hi all, I currently have a bunch of files that are 99% similar, except they have some different data in their columns. The first two rows will always look like this: Unfortunately, the first row messes with the power query, so it returns this: If I remove the first row, my file works such...

Hi all! I have this formula: But for some reason, my formula does not work? I want my formula to return "NOT BLANK AND NOT 1" if the cell contains a value that is not = 1 and not a blank cell. If the cell contains the value 1 or is blank, i want my formula to return a blank cell. Can...

Hi all, I am considering to use power query to get data for my pivot table. However, I am EXTREMELY new to both pivot tables and power query. I want to import data into this pivot table (not using power query below): I have the source data saved here: So questionnaire data file 1 is week...